|
|
#16
06-15-2017, 05:11 AM
|
||||
|
||||
In G23 enter formula:
=IFERROR(INDEX(ATMS!$I$2:$I$4961, SMALL(IF(ATMS!$B$2:$B$4961=$A24, IF(ATMS!$O$2:$O$4961<>"", ROW(ATMS!I$2:I$4961)-MIN(ROW(ATMS!I$2:I$4961))+1)), COLUMNS($G23:G23))),"") This formula needs to be confirmed with CTRL+SHIFT+ENTER not just ENTER. Then copy it across and down the chart. 
|
|
#17
06-15-2017, 10:23 AM
|
|||
|
|||
|
I am once again in your debt, NBVC!! That worked like a charm. I think you can upgrade your status from Advanced Beginner to something like, EXPERT. Thank you VERY MUCH! I will be marking this thread as SOLVED.
|
|
| Tags |
| multple sheet, search column |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
 Expiry Date Excel sheet!
|
Emperor | Excel Programming | 6 | 10-27-2015 11:50 PM |
|
Excel 2013 – need help extracting date and time from text cell plus more.
|
Art Mann | Excel | 1 | 07-18-2014 09:55 PM |
| How do you get the DATE and TIME fields to be included in an export to Excel? | tpieples | Outlook | 0 | 02-18-2013 12:11 PM |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
Windows 7 64bit 
Office 2007
Linear Mode
