Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-18-2017, 06:37 AM
OTPM OTPM is offline Formula Help Windows 10 Formula Help Office 2016
Expert
Formula Help
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with an IF Formula Cbate Excel 1 08-17-2017 07:29 AM
Formula Help Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Help With a Formula OTPM Excel 3 05-26-2016 03:42 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Formula Help Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft