Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
almost have it... need help with last bit of it.
i am currently using:
=MATCH(FIXED(B11,0,TRUE),LEFT('[Insulspan Schedule CURRENT.xls]SCHEDULE'!$F$1:$F$400,4),0) to find the row number in which column B value is located in another workbook. this works great. the only thing that i need it to do is find the next occurence if there is a duplicated value in column B. right now if there is a duplicated value it returns the fisrt instance for all. this function is in column A looking at the value in column B. -- Thank You in advance, Zab |