LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default Filtering Information

Ok. I hope I explain this correctly.

I have an excel worksheet. I have columns for "Vendor Names - Company A",
"Vendor # - Company A", "Vendor Names - Company B", "Vendor # - Company B".

I want to compare either the names or the numbers (doesn't matter which) and
find all the vendors that Company B has that Company A doesn't have.

Does that make sense? Is there an EASY way to do this?

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering out rows with duplicate information rfIPS Excel Discussion (Misc queries) 1 March 6th 07 07:51 PM
Filtering khaled shaheen Excel Discussion (Misc queries) 2 December 9th 06 11:21 AM
Functions for manipulating and filtering address information devdas777 Excel Discussion (Misc queries) 0 November 15th 06 09:33 PM
filtering via135 Excel Worksheet Functions 11 April 23rd 06 07:43 PM
trouble filtering a list. Why isn't column filtering? Pat Excel Worksheet Functions 1 July 18th 05 03:30 PM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"