Results 1 to 4 of 4

Formula picking up same number twice but it should only be counted once

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    arizona
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula picking up same number twice but it should only be counted once

    I am working on a spreadsheet were I am trying to determine how many trucks have come through our shipping yard on a daily basis. I need to enter each date, bill of lading and product. Some BOLs can have multiple products so the BOL will show up a couple times on the spreadsheet. We determine the number of trucks by the bill of lading. So if on 5/1/13, we had one truck stop by with three products the same BOL will be entered three times. Is there a certain formula or recommendation of how to resolve this issue? I have tried the IF, SUMIF and CountIF – but I can’t determine a way to have this truck show up as 1 instead of 3. Thanks for your help. Matt
    Last edited by mgren55; 05-08-2013 at 01:22 PM.

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