| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use cell value in a fomaula
hi
i am trying to search over a range only as far as the first empty cell eg row 274 = COUNTIF(BH2:BH134,AT2) what i would like to do is use the value of the first empty cell so the search would be BH2: "First empty cell",AT2 the formula below returns the row number of the last row with data in it =(MATCH("EMPTY",INDIRECT("BA1:BA"&COUNTIF(BA:BA,"< ")+1)&"EMPTY", 0)-1)) ie 250 ( this could change from worksheet to workheet) so what i am lookig to do is = COUNTIF(BH2:BH250,AT2) and BH250 to remain contant when i fill the column with a the fomula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Threaded Mode
