|
|
#2
04-16-2013, 03:52 AM
|
|||
|
|||
Hi
If I understand you correctly you could have a formula in column E (once you have pasted the smaller files into column D) that check for a match between columns A and D and puts a YES in column E, you can then filter on YES in Column E. So the formula would look like this: =IF(A1=D1,"Yes","No") Hope this helps. Tony 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
| Filtering Tasks | timvb85 | Outlook | 0 | 11-15-2010 08:30 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
| Filtering out CC's | arzsupra | Outlook | 0 | 03-11-2008 05:55 PM |
| contacts filtering | bubba622 | Outlook | 0 | 05-01-2006 03:41 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode