Forum Discussion
In a column of Data, Find 2nd, 3rd, nth occurrences and apply a value in the corresponding column
Hi all, Attached is a spreadsheet that gives an example of what I'm working with. In it, I'm trying to create a formula that searches all of column F for the exact same tag numbers. And if it...
Best if you explain what it is needs doing, what my code does which is undesirable and also show what code you already have and where it needs adjusting.
Here is a formula that is close to what I mean: But it keeps applying it to all of the cells and not the adjacent cell in the same row:
"=IF(COUNTIF(R1C[-3]:R[-1]C[-3],RC[-3])>0,"Repeat Tim","")"
"=IF(COUNTIF(R1C[-3]:R[-1]C[-3],RC[-3])>0,"Repeat Tim","")"