Lookup/Index data with multiple match

Closed
Report
Posts
2
Registration date
Thursday May 9, 2013
Status
Member
Last seen
May 10, 2013
-
Posts
2
Registration date
Thursday May 9, 2013
Status
Member
Last seen
May 10, 2013
-
Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data:
01/03/2013
Code S.No. Date
1 125 05/03/2013
5 130 01/03/2013
2 160 10/03/2013
4 180 02/03/2013
3 200 05/03/2013
2 220 01/03/2013
I am using following formula at the moment:
=IF(ISERROR(INDEX($A$1:$E$80,SMALL(IF($E$1:$E$80=$B$1,ROW($E$1:$E$80)),ROW(1:1)),2)),"",INDEX($A$1:$E$80,SMALL(IF($E$1:$E$80=$B$1,ROW($E$1:$E$80)),ROW(1:1)),2))
I trying to show only S.No on Sheet 2 on the basis of date, without leaving any blank cell but sort them with code in such a way that codes<3 will display in rows 10-25 and codes>3 will be in rows 30-35. Any suggestion will be great help

1 reply

Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Hi Jason 22

How about a pivot table.
Posts
2
Registration date
Thursday May 9, 2013
Status
Member
Last seen
May 10, 2013

Thanks for your suggestion Kevin@Radstock, but pivot table is not what am looking for because I want my data to autofill on sheet2 between rows 10 to 25 if code>3 and then continue in next column within same rows and same conditions without leaving any blank cell, I have a long data probably 1000 rows. Can you please suggest me something else or vba code. Many thanks.