Thread: Returning text, date, time, location from one Excel sheet to another
View Single Post
 
Old 06-15-2017, 05:11 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
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.
Reply With Quote