C
Connie Martin
A177 has a number. B177 has this formula: =COUNTIF($A$2:$A177,$A177)
I've had to drag that formula down now for 177 rows. Why will it not
automatically complete once I enter the number in Col. A.
G177 has a number. H177 has this formula:
=IF(G177="","",IF(G177<4,"LD","SU"))
As soon as I enter a number in G177, H177 completes automatically. I never
have to drag the formula down.
Why won't the Col. B formula work auto-fill like the Col. H formula does?
Connie
I've had to drag that formula down now for 177 rows. Why will it not
automatically complete once I enter the number in Col. A.
G177 has a number. H177 has this formula:
=IF(G177="","",IF(G177<4,"LD","SU"))
As soon as I enter a number in G177, H177 completes automatically. I never
have to drag the formula down.
Why won't the Col. B formula work auto-fill like the Col. H formula does?
Connie