Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding fields (XP)

    My spreadsheet has about 2000 records.. and about 60 columns
    Column C has 5 unique records.. contractor A, contractor B, C, D and E
    The information is on sheet 2 and sheet 1 is the summary.
    Column D and J have the result per report number (works fine)
    Column E and K have the total of records (works fine)
    Column F and L should have the total per contractor.
    I just cannot get my VLookup to work
    Thanks for helping me

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding fields (XP)

    Does this give you what you want?
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    May 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding fields (XP)

    That is exactly what I wanted. No wonder my vlookup didn't work
    Thanks heaps and merry christmas

Posting Permissions

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