I would like to have the below formula modified to refer to a range of cells.
The above range shows a9:a2473. However the end range can change from sheet to sheet.
row 9 is always the same. The latter part only needs modifying from Countif.....
At the moment the other cell formulas just refer to a cell with 2473 or whatever number of rows there are in the sheet
and I would like to do the same with the above formula rather than having to modify each time.
Any help much appreciated.
ps..... or maybe there is a formula that can refer to the last row of a spreadsheet