Forum Discussion
I need HELP with excel sheet sample below
Hello, I have same numbers with same colours.(Ex: Yellow for 9101) I want to fill B column with 1 to infinity(1,2,3,4.....) for same numbers or colours(it does'n matter becasue every number ...
It works and your example was very helpful for me. Thank you so much!!
Your formula is very good but I just found a mistake now.
If the number is 1 in A1 column, B1 column is filling automatically as 1 but it should be different for each 1.
In the excel sheet sample below, A-B column was done with formula, and D-E column was by hand so you can see the difference for number 1.
Anil, which of two suggested formulas do you mean? First one returns correct result
- Hi Anil,
I agree with Sergei. VLOOKUP is not required, simple COUNTIF will work just fine. I think I overcomplicated it.
Regards
Nikhil
