Comparing similar data on different sheet tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet with two sheet tabs. Sheet1 has 900 construction
projects at 600 schools (some schools have more than one project and the
school name is listed in Column D). Sheet2 has a list of the 300 schools I am
working on which is listed in Column A. Is there a way, using the formula
bar, to compare the list of 300 schools on sheet2 to the 600 schools on
sheet1 so that I can filter sheet1 to show only the schools I am working on?
 
I don't know what you mean by "using the formula bar".
If you want to see the data in Sheet1 that pertains to just one school,
simply use Auto Filter.
If this doesn't help, please post back and explain what you want to do.
HTH Otto
 
"Compare two lists of data" is a generic term and can mean many things.
Exactly what do you want to do once you have "compared" the two lists? HTH
Otto
 
Back
Top