| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find last cell in range with data, display cell address
Hi,
I have scoured these posts but haven't quite found what I'm looking for, hopefully someone can help.... Is it possible to write a formula that will search a range (D18:V18), find the last cell in that range with data, then show the cell address, not the value of the cell, in a different cell? I have been thinking that maybe I will need an array formula, or at worst, a macro or VBA? Any response will be greatly appreciated. sevi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display a cell address | Excel Worksheet Functions | |||
| find email address in a cell | Excel Worksheet Functions | |||
| How to find the address of the min cell within a range | Excel Worksheet Functions | |||
| Is there a way to find the address of a cell with a certain value? | Excel Worksheet Functions | |||
| Display the address of cell with max value | Excel Worksheet Functions | |||
Threaded Mode
