Multiple matches in a single column

[shivspatil]

Hi Gurus, I was trying to index the dates column to match with some criteria that the dates can be listed per event vertically. Attached in the book.

Thanks in advance.

Shiva

[samba_ravi]

Try below array formula and copy across
D2=IFERROR(SMALL(IF($B$2:$B$26=D$1,$A$2:$A$26),ROWS(D$2:$D2)),"")


...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[AlKey]

Or use as regular formula
Enter in D2 and drag formula across and down

Please Login or Register  to view this content.

[shivspatil]

Thats perfect sir.. Thank you

[shivspatil]

Its perfect too Guru. Thank you very much