| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last cell with data in a range
On Mar 25, 1:17*pm, Ziggy wrote:
On Mar 25, 11:04*am, Ziggy wrote: On Mar 24, 9:31*pm, "Ashish Mathur" wrote: Or this =INDIRECT("N"&MAX(IF($N$80:$N$122<0,ROW($N$80:$N$ 122)))) Substitute the "N" for your column and also adjust the ranges. I should have stated this is an ARRAY formula and needs the Cntrl-Alt- Enter Should be Ctrl-Shift-Enter.. sorru bout that |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| Summed Cell won't update as I add data into the cell range... | Excel Worksheet Functions | |||
| How to enter data in one row cell only in a cell range | Excel Worksheet Functions | |||
| Data range reference in a cell | Charts and Charting in Excel | |||
Threaded Mode
