Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

hi i am trying to write a formula that flags if two requirements are met - a dupe check in one column with a seperate dupe check in another. For example if column A is a dupe and also the information in column B is a dupe then show this as a dupe or if not then show blank Thanks
Solved by X. F. in 28 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/12/2017 - 02:48
Hi
Excelchat Expert 04/12/2017 - 02:48
Welcome to see you here ...
Excelchat Expert 04/12/2017 - 02:49
Are you there ?
User 04/12/2017 - 02:49
hi
User 04/12/2017 - 02:49
yes
Excelchat Expert 04/12/2017 - 02:49
Great
Excelchat Expert 04/12/2017 - 02:49
Can you draw the sample data
Excelchat Expert 04/12/2017 - 02:49
thanks
User 04/12/2017 - 02:51
ok so what i need is a formula that flags if that works out if the info in column b is a dupe
User 04/12/2017 - 02:51
and then if that is a dupe is the info in c also a dupe
Excelchat Expert 04/12/2017 - 02:52
Okay
User 04/12/2017 - 02:52
column B is the main data and then c is the secondary
Excelchat Expert 04/12/2017 - 02:52
Ok
User 04/12/2017 - 02:54
for example c2 would be unique
User 04/12/2017 - 02:54
and also c5
Excelchat Expert 04/12/2017 - 02:59
There ?
User 04/12/2017 - 03:00
yes
Excelchat Expert 04/12/2017 - 03:00
select the column B from top
User 04/12/2017 - 03:01
what next
Excelchat Expert 04/12/2017 - 03:02
go to conditional formatting
Excelchat Expert 04/12/2017 - 03:02
from format
User 04/12/2017 - 03:02
ok
Excelchat Expert 04/12/2017 - 03:02
apply highlight a duplicate value
User 04/12/2017 - 03:03
how
Excelchat Expert 04/12/2017 - 03:03
have you opened the file on local pc
User 04/12/2017 - 03:03
yes
User 04/12/2017 - 03:04
i thought you would help me write the formula
Excelchat Expert 04/12/2017 - 03:04
select the column B from top
User 04/12/2017 - 03:04
and then show it
Excelchat Expert 04/12/2017 - 03:04
okay
User 04/12/2017 - 03:04
now i only have 3 minutes and the rest has been wasted
Excelchat Expert 04/12/2017 - 03:05
no problem , we can extend it
User 04/12/2017 - 03:05
ok
User 04/12/2017 - 03:05
thanks
Excelchat Expert 04/12/2017 - 03:05
I am working on local pc and sending you files
User 04/12/2017 - 03:05
ok thanks
Excelchat Expert 04/12/2017 - 03:05
as some features are missing in online
Excelchat Expert 04/12/2017 - 03:14
Kindly download this file and check
[Uploaded an Excel file]
Excelchat Expert 04/12/2017 - 03:14
If you still have any question I would love to answer
User 04/12/2017 - 03:15
thats brilliant
User 04/12/2017 - 03:15
thank you
User 04/12/2017 - 03:15
just what i needed
Excelchat Expert 04/12/2017 - 03:15
thanks
User 04/12/2017 - 03:15
:)
Excelchat Expert 04/12/2017 - 03:15
its my pleasure to help you
Excelchat Expert 04/12/2017 - 03:16
stay tuned with us, if you have any excel related issue
User 04/12/2017 - 03:16
thanks will do
Excelchat Expert 04/12/2017 - 03:16
kindly press the done button ! and dont forget to press on 5 stars

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc