| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Indirect address inside ""
=COUNTIF(F$2:F$1561;"0.9") J4=0.9
I want to drag above command, downward. Value of 0.9 is stored in J4. How can I produce J4 with formula so that it repeats while dragging. I face this problem a lot. I think by combination of Indirect and Row it is possible to solve. I tried some combination but they didn't work. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
| Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
| Address from one worksheet to another | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| How to Stop AutoOpening of XLS (Of2003) inside IE | Excel Discussion (Misc queries) | |||
Threaded Mode
