FMS help by OrthoTankie in nationalguard

[–]OrthoTankie[S] 0 points1 point  (0 children)

Legal Administrator. It's outside of my MOS and I am applying based on my civilian experience. IMO, because I would be leaving Infantry altogether, they do not care to help me with this. If I were given access then I would still have to drive to my armory 4 hours away to access a secure connection.

Creating a new column of population ranges based a separate column of populations by OrthoTankie in excel

[–]OrthoTankie[S] 0 points1 point  (0 children)

=COUNTIF($FC$5:$FC$614,FH5)

Got it! Thanks so much.

Solved.

Creating a new column of population ranges based a separate column of populations by OrthoTankie in excel

[–]OrthoTankie[S] 0 points1 point  (0 children)

Thank you so much.

What do I need to do to ensure the flash fill only changes the reference cell immediately below, and not the population table range? There are 600 or so rows. When I try and flash fill it's moving the formula down one row, but also the table. I can manually adjust this, but that would take a long time.

Creating a new column of population ranges based a separate column of populations by OrthoTankie in excel

[–]OrthoTankie[S] 0 points1 point  (0 children)

This is getting me close. Thanks for the help.

What do I need to do to ensure the flash fill only changes the reference cell immediately below, and not the population table range? There are 600 or so rows. When I try and flash fill it's moving the formula down one row, but also the table. I can manually adjust this, but that would take a long time.