| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a list in Excel for a matching criteria
Here is solution:
=IF(INDIRECT("R" & ROW() & "C" & MATCH($F$1,$A$1:$E$1,0),0)="H",A3,"") Paste this formula in Cells F3 with following conditions: - F1 should contain date from your data - F2 empty row - Column E is blank - Columns A:D should contain ur data Hereunder is sample A B C D E F 01-07-2012 02-07-2012 03-07-2012 03-07-2012 John H H Gary H Paul H H Paul For any detail ping me or visit www.Excelolozy.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating list from values that meet multiple criteria from other sheet | Excel Worksheet Functions | |||
| creating a list based criteria | Excel Programming | |||
| Display top 5 items from a list with matching criteria? | Excel Discussion (Misc queries) | |||
| Create list of text matching criteria | Excel Worksheet Functions | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
Threaded Mode
