| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell number replacement
I need to put a formla into a cell so that it chooses the last entry in a
column. I have doe this once before but can't remember whats required. I need to say =A? where ? is "count A3:A300" so the answer in the formula point to ,say, A25 if thats the last entry in the column. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell number replacement
Hi,
If its a numeric value try this =LOOKUP(10^23,A1:A300) or if it could be text =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A300))*(A1:A3 00<"")))) Mike "red" wrote: I need to put a formla into a cell so that it chooses the last entry in a column. I have doe this once before but can't remember whats required. I need to say =A? where ? is "count A3:A300" so the answer in the formula point to ,say, A25 if thats the last entry in the column. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell number replacement
Thanks Mike, both worked a treat!
"Mike H" wrote: Hi, If its a numeric value try this =LOOKUP(10^23,A1:A300) or if it could be text =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A300))*(A1:A3 00<"")))) Mike "red" wrote: I need to put a formla into a cell so that it chooses the last entry in a column. I have doe this once before but can't remember whats required. I need to say =A? where ? is "count A3:A300" so the answer in the formula point to ,say, A25 if thats the last entry in the column. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell number replacement
Glad I could help
"red" wrote: Thanks Mike, both worked a treat! "Mike H" wrote: Hi, If its a numeric value try this =LOOKUP(10^23,A1:A300) or if it could be text =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A300))*(A1:A3 00<"")))) Mike "red" wrote: I need to put a formla into a cell so that it chooses the last entry in a column. I have doe this once before but can't remember whats required. I need to say =A? where ? is "count A3:A300" so the answer in the formula point to ,say, A25 if thats the last entry in the column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bulk replacement of cell reference within formula | Excel Worksheet Functions | |||
| How do I randomly select a cell without replacement? | Excel Discussion (Misc queries) | |||
| number replacement | Excel Discussion (Misc queries) | |||
| #N/A Replacement | Excel Discussion (Misc queries) | |||
| Replacement | Excel Discussion (Misc queries) | |||
Linear Mode
