inventory comparison

[ekoot]

I have an excel spreadsheet with several columns of data, from over a thousand bikes scanned from a yearly inventory. I also have a second tab in the same workbook with the official inventory.

I want to compare the two spreadsheets, using the barcode column (in red) in each and produce a list, or simply highlight on the official inventory line items missing, with their internal for tracking purposes.Thanks for your help!

Gurus GO!

[Steve R]

See attached workbook

[JBeaucaire]

On the BlindInventory sheet, color all the cells in Column A yellow, then use this conditional format to remove the coloring (no fill) based on checking the BarCode.

=MATCH(A2,BarCodeFas,0)

I also created a NamedRange to cover the entire range of Bar Codes on the FAS page.

[DonkeyOte]

I'm not sure which sheet is which (official etc) but to answer your question:

see MATCH in XL Help

You can use this to determine as to whether or not given code on "blind inventory" exists on "FAS", eg

AY2: =REPT("Missing",ISNA(MATCH($A2,FAS!I:I,0)))

the above copied down to last row would list those codes on blind sheet that are not present on FAS sheet.

[ekoot]

You are all infinitely intelligent and really fast. thanks for the contributions, any other other ideas would be appreciated