Problem with IDEX + MATCH
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:K1 8,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 |
All times are GMT +1. The time now is 06:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com