Results 1 to 7 of 7

Group Companies and Identify the ones that have buyer and seller

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2003
    Posts
    21

    Group Companies and Identify the ones that have buyer and seller

    See attached. I have the company name numbered off in sequence but I am trying to group the same company together and then identify the companies that have BOTH a Buyer and Seller transaction. I was thinking of writing a formula next to it that might be able to identify the group of same company and then identify if out of that group it has both buyer and seller and put a "1" and if not then a "2" and later i can filter to display the "1". Can anyone help with this or propose an easier method please????

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1