| 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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Indirect address inside ""
Try putting an absolute reference to cell J4 inside the COUNTIF:
=COUNTIF(F$2:F$1561;"" & $J4) As you copy this formula across, it will always reference the value in cell J4. -- Brad "Khoshravan" wrote: =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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Indirect address inside ""
Thanks. It was an interesting solution.
-- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "byundt" wrote: Try putting an absolute reference to cell J4 inside the COUNTIF: =COUNTIF(F$2:F$1561;"" & $J4) As you copy this formula across, it will always reference the value in cell J4. -- Brad "Khoshravan" wrote: =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 |
| Reply |
| 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) | |||
Linear Mode
