| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Duplicate UPC Codes in 1 Column
Thank you Bryon720. This worked for me also. J
"Byron720" wrote: Another way is to use a Pivot Table just for that column. The layout should have A1(heading) under row and Count of A1 under DATA. The result will give you all the UPC's and the number of times they repeat "Dave F" wrote: Someone may have a more elegant method, but this works for me. Assume the UPC codes are in range A2:A100 and A1 is a column heading. In B2 enter the formula =IF(A2=A1,1,"") and fill down. Wherever there is a 1 in column B you have a duplicate UPC code. Dave -- Brevity is the soul of wit. "JeremyH1982" wrote: My question is how? How can I find out if there are duplicates in the UPC Code Column? -- Jeremy Himmelreich Computer IT Manager http://home.comcast.net/~jeremy1982 http://www.willitshoe.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Threaded Mode
