duplicated information

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicated information

Duplicated information

resolvedResolved · Urgent Priority · Version 2013

Lilian has attended:
Excel Advanced course

Duplicated information

Hi,

I`ve been asked if its possible to create a function with the criteria that will advise if there are duplicated information.

EI.

ColumnD ColumnE (need to create a function)
VTQOSF Match
VTQOSF
W6UTE9 Match
W6UTE9
PDX367
PDKDFJ
WD6Y5V Match
WD6Y5V
PZ6SMH

Is it possible?

Many Thanks
Regards,
Lilian


RE: Duplicated information

Hi Lillian

Thank you for using our forum

Have you tried using conditional formatting? It won't mark it with the word match but it will mark all duplicate entries a certain colour making it easier to identify.

Another method you could use is sorting the data by Column D and in Column E use an IF statement to check if it's a duplicate and if it is to add the word match

=IF(A8=A9,"Match","")

Though this option would only work if you kept the data sorted

Hope this helps

Kind regards
Wendy Canelas
Microsoft Office Trainer

Thu 31 May 2018: Automatically marked as resolved.


 

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips


Server loaded in 0.05 secs.