Hi,

I want to find and count the number of times a given number has appeared in the same column, based on its position in the column. So if it's the first time it appeared in the column, I want to return 1, if it's the second time it appeared, I want to return 2, etc. I'm thinking of using the formula count, but how do I tell it to "count this number up to this point", since the range is conditional to the position of the number?

An image is worth a thousand words :

Thanks a lot

I want to find and count the number of times a given number has appeared in the same column, based on its position in the column. So if it's the first time it appeared in the column, I want to return 1, if it's the second time it appeared, I want to return 2, etc. I'm thinking of using the formula count, but how do I tell it to "count this number up to this point", since the range is conditional to the position of the number?

An image is worth a thousand words :

Thanks a lot

Last edited: