Thread: [Solved] Formula Help
View Single Post
 
Old 10-18-2017, 06:37 AM
OTPM OTPM is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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
Reply With Quote