| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get data with certain condition
Hi,I would like to get the data from same row or same coloum(which last
figure shown in same row or colum). Example as below, A1=15/3/2008 A2=25/4/2008 A3=nothing shown A4=nothing shown A5=Yes A6=No A7=nothing shown A15 = I hope I can get the last figure or date or word shown in the same column (ie.No). If all the coloum is blank then show with "-" , any solution ? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Importing data using a date as the condition | Excel Discussion (Misc queries) | |||
| copy data to another sheet on condition | Excel Worksheet Functions | |||
| Sum of data where a condition applies | Excel Discussion (Misc queries) | |||
| Retaining Data when a condition changes | Excel Worksheet Functions | |||
Threaded Mode
