+ Reply to Thread
Results 1 to 3 of 3

Trying do extract only certain information on a new tab

  1. 10-23-2008, 11:05 AM #1
    Beanner
    Beanner is offline
    Registered User
    Join Date
    10-23-2008
    Location
    ohio
    Posts
    1

    Trying do extract only certain information on a new tab

    Hello,

    I am looking for a formula or macro that will take

    BOL Truck Cost Charged Person

    88005 Truck $40.00 $52.00 Michelle
    88010 Carrier $30.00 $45.00 Peter
    88015 Carrier $25.00 $37.00 Stacy

    On a seperate tabs (Michelle) (Peter) (Stacy) and look in "person" column. If the person is Michelle return the BOL, truck,cost.... ( there will be a bunch of these rows not just these three. I don't want empty rows under each person, and for some reason I am suppose to do this in Excel instead of Access.

    Anyone help?
    Last edited by Beanner; 10-23-2008 at 11:14 AM. Reason: title
    Reply With QuoteRegister To Reply
  2. 10-23-2008, 11:08 AM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 10-23-2008, 11:19 AM #3
    Cheeky Charlie
    Cheeky Charlie is offline
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    If you can move the names column to the front (i.e. to column A) this can be done with a simple unique-counter formula and vlookups.

    The better way, however, would be a pivot table - although we might still need a duplication check.

    See attached.

    HTH
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1