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.