Hi Friends
I am facing a trouble in Index match with date value,
here with enclose the sample file.
Thanks in advance
Hi Friends
I am facing a trouble in Index match with date value,
here with enclose the sample file.
Thanks in advance
You need to explain what you want. A non-working formula tells us nothing.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Glenn,
I need a suitable formula in column K, specified Date in Column I,
data pull from Range A2 to D133.
Maybe try at K2
=IFERROR(INDEX(CuID,SMALL(IF($B$2:$B$133=I2,ROW($B$2:$B$133)-ROW($B$1)),COUNTIFS(I$2:I2,I2))),"")
confirm by Ctrl+Shift+Enter
Please confirm that you are still using Excel 2007.
Thanks Bo_Ry -
this formula works Exactly.
Thanks a lot
Yes .... Still using Excel 2007.
If interested, here is a non-array version that works with Excel 2007:
=IFERROR(INDEX($D:$D,SMALL(INDEX(($B$2:$B$133<>I2)*10^10+ROW($B$2:$B$133),0),COUNTIFS(I$2:I2,I2))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks