Simon Lloyd
05-17-2008, 05:06 AM
Hi all, i am using data validation drop down (B13) to supply some data eg. ABC 123, i want to be able to find the row that this appears on in column B and then do something like the following:
in H2 i am using {=SMALL(IF($B$1:$B$10=B13,ROW($B$1:$B$10)),ROW()-ROW($B$1))} to find the row the data appears on
=MIN(D&row(H2):f&row(H2))
I have tried using:
{=1*MID(B13,MATCH(TRUE,ISNUMBER(1*MID(B13,ROW($1:$10),1)),0),COUNT(1*MID(B1 3,ROW($1:$10),1)))} to extract just the number and use that.
Essentially i am trying to find the minimum value of a row containing the data found in the dropdown.
Any ideas?
in H2 i am using {=SMALL(IF($B$1:$B$10=B13,ROW($B$1:$B$10)),ROW()-ROW($B$1))} to find the row the data appears on
=MIN(D&row(H2):f&row(H2))
I have tried using:
{=1*MID(B13,MATCH(TRUE,ISNUMBER(1*MID(B13,ROW($1:$10),1)),0),COUNT(1*MID(B1 3,ROW($1:$10),1)))} to extract just the number and use that.
Essentially i am trying to find the minimum value of a row containing the data found in the dropdown.
Any ideas?