Results 1 to 10 of 10

Count unique licence plates per refuelling

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2020
    Location
    Portugal
    MS-Off Ver
    Office 365 Enterprise
    Posts
    6

    Count unique licence plates per refuelling

    Hi guys,

    i need a formula that counts the unique license plates - repeated dozens of times, each per refuelling throughout the year - but also that takes into account the fact that each license plate belongs to a determined segment

    For ex.
    column A lists various license plates, one per each refuelling value (in column B) and on column C we already have that the license plate from column A belongs to the car segment X.
    The objective is for me to count that segment A has 2 cars, segment F one, etc....

    just to clarify: I need to count each license plate irregardless of it being 12-AB-34; the xls I'm looking at has over 40,000 lines so the main point is just to know the number of unique license plates that exist in that particular segment

    example xls attached (or so I hope)
    Attached Files Attached Files
    Last edited by AliGW; 09-22-2021 at 04:55 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Returning the most recent date based on specific text
    By fearindex87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2020, 06:28 AM
  2. THANKS to the under appreciated
    By rkgodoit in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-14-2015, 12:06 PM
  3. Complicated Excel Lookup Count - Any help appreciated
    By deejaynv in forum Excel General
    Replies: 4
    Last Post: 01-09-2015, 03:03 PM
  4. Got there in the end. Any help appreciated! :)
    By ExceI in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2010, 11:46 AM
  5. Somebody help me please - any help much appreciated!
    By bubbleou in forum Excel General
    Replies: 1
    Last Post: 03-28-2007, 03:13 PM
  6. Bug help appreciated
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2007, 06:24 PM
  7. [SOLVED] Any help much appreciated
    By Ryk in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 12:03 PM

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