| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing similar data on different sheet tabs
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting data from one excel sheet into poreset tabs? | Excel Discussion (Misc queries) | |||
| Comparing 2 tables with similar content | Excel Discussion (Misc queries) | |||
| comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
| a similar convention for tabs/wksts as in for R[1]C[1]? | Excel Discussion (Misc queries) | |||
| Comparing data in two similar worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
