Previous Topic Next Topic

Lookup/Index data with multiple match

Closed
Jason 22 Posts 2 Registration date Thursday May 9, 2013 Status Member Last seen May 10, 2013 - May 9, 2013 at 06:06 PM
Jason 22 Posts 2 Registration date Thursday May 9, 2013 Status Member Last seen May 10, 2013 - May 10, 2013 at 04:58 PM
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
Related:

1 response

Answer 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
May 10, 2013 at 01:45 PM
Hi Jason 22

How about a pivot table.
0
Jason 22 Posts 2 Registration date Thursday May 9, 2013 Status Member Last seen May 10, 2013
May 10, 2013 at 04:58 PM
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.
0

Similar discussions

Find my Gmail account
Dabang -
HelpiOS -

1 response
AMD data change update new data to DMI
Luis -
dwebb -

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response