P
pgarcia
Hello all,
I'm using the folling fomulas and all work will, however, if my list has
more the one of the same number, how do I move to the next number and pick up
the info?
E.g.
46
37
23
22
21<---- this is a good number
21<---- so is this but the customer info is deffrent
21<---- and is this too7
11
8
Setup:
N1 =IF('Sheet2'!K2="","",'Sheet2'!K2-ROW()/10^10)
O1 =IF(ROW(N1)>COUNT($N:$N),"",INDEX(N:N,MATCH(LARGE($N:$N,ROW(N1)),$N:$N,0)))
P1 =ROUND(O1,2)
A1 =INDEX('Sheet2'!$A$2:A18,MATCH(P1,'Sheet2'!$K$2:K18,0))
Data:
Sheet2 A1
Customer Name
NET SHOPS
NET SHOPS
POWER TRACK'TRAFFIC'SVC
HUNTER DOUGLAS
UNITED TECHNOLOGIES
PAYMENTECH MCVISA
CONTINENTAL (TRAFFIC SERVICE)
PAYMENTECH AMEX
PAYMENTECH MCVISA
PAYMENTECH MCVISA
CONTINENTAL (TRAFFIC SERVICE)
TOMKINS INDUSTRIES
POWERED BY FORD
GALLERIA GIGI
BROOKS SPORTS
SAMSUNG PACIFIC INTERNATIONAL
PAYMENTECH MCVISA
Sheet2 B1
Days Old
4
2
8
4
1
21
1
37
11
46
4
2
17
21
22
21
23
Thanks
I'm using the folling fomulas and all work will, however, if my list has
more the one of the same number, how do I move to the next number and pick up
the info?
E.g.
46
37
23
22
21<---- this is a good number
21<---- so is this but the customer info is deffrent
21<---- and is this too7
11
8
Setup:
N1 =IF('Sheet2'!K2="","",'Sheet2'!K2-ROW()/10^10)
O1 =IF(ROW(N1)>COUNT($N:$N),"",INDEX(N:N,MATCH(LARGE($N:$N,ROW(N1)),$N:$N,0)))
P1 =ROUND(O1,2)
A1 =INDEX('Sheet2'!$A$2:A18,MATCH(P1,'Sheet2'!$K$2:K18,0))
Data:
Sheet2 A1
Customer Name
NET SHOPS
NET SHOPS
POWER TRACK'TRAFFIC'SVC
HUNTER DOUGLAS
UNITED TECHNOLOGIES
PAYMENTECH MCVISA
CONTINENTAL (TRAFFIC SERVICE)
PAYMENTECH AMEX
PAYMENTECH MCVISA
PAYMENTECH MCVISA
CONTINENTAL (TRAFFIC SERVICE)
TOMKINS INDUSTRIES
POWERED BY FORD
GALLERIA GIGI
BROOKS SPORTS
SAMSUNG PACIFIC INTERNATIONAL
PAYMENTECH MCVISA
Sheet2 B1
Days Old
4
2
8
4
1
21
1
37
11
46
4
2
17
21
22
21
23
Thanks