Home

Comparing Spread Out Data in two excel sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-859809%22%20slang%3D%22en-US%22%3EComparing%20Spread%20Out%20Data%20in%20two%20excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859809%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pretty%20basic%20task%20that%20I'm%20sure%20Excel%20can%20do%20for%20me%2C%20but%20I'm%20a%20total%20amateur%20and%20need%20some%20help%20figuring%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20excel%20sheets%20that%20are%20being%20generated%20from%20different%20programs%20-%20both%20have%20records%20of%20ticket%20sales%20to%20the%20same%20event%20from%20different%20databases.%20Ideally%20they%20match%2C%20but%20I'm%20supposed%20to%20reconcile%20them%20to%20each%20other%20to%20make%20sure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20excel%20spreadsheet%20has%20them%20listed%20in%20rows%20and%20columns%20of%20date%2C%20name%2C%20memo%2C%20and%20amount.%20The%20other%20has%20them%20listed%20by%20name%20and%20amounts%2C%20but%20they're%20in%20multiple%20different%20columns%20(there%20are%20different%20groupings%20based%20on%20the%20kind%20of%20ticket%20they%20purchased%20-%20it%20looks%20visually%20like%20separate%20tables%2C%20but%20they%20aren't%20actual%20excel%20tables).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20for%20me%20to%20be%20able%20to%20compare%20values%20from%20the%20first%20spreadsheet%20(without%20necessarily%20an%20exact%20match%2C%20like%20the%20last%20name)%20and%20highlight%20matches%20with%20the%20different%20cells%20in%20the%20second%20sheet%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20attached%20the%20two%20formats%20of%20the%20different%20sheets%20below%2C%20with%20information%20changed%20and%20blanked%20out.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-859809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
dkimball
Occasional Visitor

I have a pretty basic task that I'm sure Excel can do for me, but I'm a total amateur and need some help figuring it out.

 

I have two excel sheets that are being generated from different programs - both have records of ticket sales to the same event from different databases. Ideally they match, but I'm supposed to reconcile them to each other to make sure.

 

One excel spreadsheet has them listed in rows and columns of date, name, memo, and amount. The other has them listed by name and amounts, but they're in multiple different columns (there are different groupings based on the kind of ticket they purchased - it looks visually like separate tables, but they aren't actual excel tables).

 

Is there any way for me to be able to compare values from the first spreadsheet (without necessarily an exact match, like the last name) and highlight matches with the different cells in the second sheet?

I've attached the two formats of the different sheets below, with information changed and blanked out.   

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies