I am new to this forum. I use Excel 5.0 at work to write Preventive Maintenance schedules for manufactuing equipment.
I have both 90 and 120 day cycles for up to 20 different types of equipment, each of which has rules or parameters to abide by. I'm trying to learn how to check for duplicate entries on a worksheet, and also do a Vlookup in the 3 to four months prior.
Thank You
Check for duplicate entries
-
-
-
Welcome to the forum
Duplicates can be shown by using data validation in the data menu using a formula. This can highlight the entries that are the same
or
You can use an array formula to determine if a range has duplicates. An array formula is a special formula that must be entered by holding the Ctrl + Shift + Enter when finished. this will put {} brackets around it. The formula below (array entered) will return TRUE if the range in the formula is unique. FALSE means duplicates.
=MAX(COUNTIF(A1:A7,A1:A7))=1
Have you tried looking at XL Help on VLOOKUP?
HTH
:guitar:
-
Hi Gary
Try this link for Duplicates: http://www.ozgrid.com/Excel/Formulas.htm and This Workbook for VLOOKUP.
-
Hi, here is a simple approach for finding duplicates:
1st sort your data on the col you want to check for dups
enter in C2 =IF(C2=C1,"Duplicate","")
then fill down.
2rrs
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!