Find first value

[adamhenderson]

Hi

I want to create a macro to search the C column for the first cell that contains a 1 then put the corresponding A value in the next available cell in the D column. So i can then get a long list of those A values.

Any help would be Appreciated

[carddards]

Please elaborate. What you gave is unclear.

[adamhenderson]

ok sorry

I have a list of random numbers from 1 to 52 in the B column. I then have in the C column an if formula that gives a 1 if the value in the B column is between 1 and 13. Also i have row numbers in the A column. I need to put the first row number where the C column is 1 in the first blank cell in the D coulmn. So every time i refresh the random numbers i get a new value in the D column. So after refreshing the data i get a large list of numbers.

Hope i made myself a bit clearer

thanks

[carddards]

So you want the row numbers of all the 1s in column C to be shown in column D?

[adamhenderson]

only the first 1. And then when i refresh, the new first 1 is displayed in the next value in the D column.

[Leith Ross]

Hello adamhenderson,

The data keeps changing not due to a query but due to the formulae you have in column "C". Unless these are removed or calculation turned off, the resulting search will not reflect the final data correctly.

Sincerely,
Leith Ross

[adamhenderson]

ok tanks for you help anyway

[Dave69rock]

Hi Adam

I think this is what you were looking for.

Please find attached your sheet with the code

Dave