i have 2 table
the first one is that
t1.jpg
this is the second
t2.jpg
i like to pull the arr. time from the green table to column C in the yellow table.
the problem is that i have bus number couple of time un each table.
the original table is much bigger
tnx in advanced for all repliers
bus example (Autosaved).xlsx
Your file is corrupt ,please upload another one
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
work fine to me
but uploaded again
Hi Asafswis,
In my knowledge I don't know any formula to do this.
the bus nos. should be unique to in order to fetch values from another table from vlookup or index functions.
Pls try to attach some alphabets or char eg 115A , 115B etc
Maybe some one else knows a better solution to this
If this helped and you wish to say thanks, then Please click on the Star* icon below this post.
Not for me.
Can you upload without the "Auto-save" extension?
bus o 115 is 3 times in green table but only 2 times in yellow.
Which times do you need in yellow table?
First two?The closest one?
yes the first two
=IFERROR(INDEX($K$6:$K$15,SMALL(IF($J$6:$J$15=$D6,ROW($K$6:$K$15)-ROW($K$6)+1),COUNTIF($D$6:D6,D6))),"")
Confirm Control+shift+Enter
Copy of bus example.xlsx
Hmm yellow table has 3 entry for 225 whereas green only two..
I have pulled out only first two.
cheers man.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks