Seamus2626
asked on
Match Formula?
Hi,
I have a row of data in column B, there may be data anywhere from B1-B10,000. Can i return to M1, M2, M3 etc any results.
The data in ColB will always be "Double Div"
So if theres an instance return it, i can guarantee this wont happen more than 50 times so i could drag down till then.
Ive attached the file
Thanks
Seamus
CP-Report.zip
I have a row of data in column B, there may be data anywhere from B1-B10,000. Can i return to M1, M2, M3 etc any results.
The data in ColB will always be "Double Div"
So if theres an instance return it, i can guarantee this wont happen more than 50 times so i could drag down till then.
Ive attached the file
Thanks
Seamus
CP-Report.zip
Seamus - do you mean col A? Col B is empty. An instance of what - not clear what you are looking for?
What exactly do you want returned?
OK, I think I see now. You want B37, B195 returned in M1, M2 etc?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry guys, i have to shoot, i will return first thing Mon Morning.
Thanks for the help
Seamus
Thanks for the help
Seamus
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Should be, in M6 and down.
ASKER
Thanks lads, both worked perfectly!