**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.*