Excel: Comparing spreadsheets and finding the difference

• CrashAndBurn [TS] on 15 Jul 16 @ 04:21 PM #

  Tanong: Ano ang best way to compare 3 different spreadsheets to see which cell have different content?
  
  Meron akong 3 spreadsheets as per below:
  
  A - extract from Peoplesoft
  B - extract from AD
  C - extract from a custom app
  
  Gagawin kong master yung A. So need ko i compare yung A with B and C.
  
  Halimbawa all 3 spreadsheets have the following column (Emp Number, First Name, Last Name)
  
  Need ko ma check kung pareho ba lahat ng fields for each employee with that of A
  
  A - 001 John Doe
  B - 001 John Doe
  C - 001 Jane Doe
  
  Dapat ma pickup na hinde pareho yung first name field sa spreadsheet C if compared to A
  
  Need kasi para ma itama yung mga maling entries
  
  Salamat sa mga Excel guru :)

• CrashAndBurn [TS] on 16 Jul 16 @ 04:27 AM #

  Anyone?

• fakuryu on 16 Jul 16 @ 04:37 AM #

  =vlookup ang pinakamadali mo na magagawa dyan, hindi ko ma explain ng maayos kasi mas nadadalian ako mag explain pag nasa akin data :D
  
  -- edited by fakuryu on Jul 16 2016, 04:41 AM

• stealthbio on 16 Jul 16 @ 04:43 AM #

  Yup combination ng =vlookup at pivot table solution dyan.

• Bravoexo on 16 Jul 16 @ 04:44 AM #

  I usually just do If statements

• CrashAndBurn [TS] on 16 Jul 16 @ 05:36 AM #

  @all i can send a sample data, just need to see the formula or is vlookup more of a function in excel?

• triptolemus on 16 Jul 16 @ 07:18 AM #

  vlookup/pivot is powerful :-)