| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
last entry done in certain area
Dear friends..
i want your help regarding this subject.. can anyone help me? actually, i have a big database in excel.. dont want to go last and first... i want to know in certain cell (B1) which is the last entry had done in A:A. i will prefer any formula.. thanks in advance suresh tp |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
last entry done in certain area
If column A is of numeric type:
=LOOKUP(9.99999999999999E+307,A:A) If column A is text-typed: =LOOKUP(REPT("z",255),A:A) SURESH wrote: Dear friends.. i want your help regarding this subject.. can anyone help me? actually, i have a big database in excel.. dont want to go last and first... i want to know in certain cell (B1) which is the last entry had done in A:A. i will prefer any formula.. thanks in advance suresh tp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| last entry from certain area | Excel Worksheet Functions | |||
| Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
| Resize chart area without resizing plot area | Charts and Charting in Excel | |||
| Volatile print area | Excel Discussion (Misc queries) | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
