Formula Help
Hi
I am looking for some help with a formula for searching for duplicate entries in two adjacent columns and then adding "0.3" to each of the duplicate column values.
I have Data as follows:
Column D Column E
1 1
3 2
2 2
1 1
I want the duplicate row to become:
1.3 1.3
Any help would be appreciated.
Thanks in advance.
Tony
|