| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
| Auto Fill | Excel Discussion (Misc queries) | |||
| Auto fill | Excel Discussion (Misc queries) | |||
Threaded Mode
