Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy exact value from one cell to new formula in another cell
I created a countif formula, but have a great amount of exact values to put
in a number of cells which will count up another sheet with those values. Is there an easier way to input the formula for each cell other than editing the copied formula over and over again? i.e. =COUNTIF(Sheet2!G9:G30007, "=reddog1") I will need to change reddog1 to reddog1, reddog3, bluecat1, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |