Results 1 to 6 of 6

Count Unique instances across several Columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2012
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Count Unique instances across several Columns

    I have a spreadsheet with several columns (20 odd) and several thousand rows (10187!)
    See "data" Tab for a watered down version
    I need to count the total number of shifts worked (for a given period - say monthly)

    Ie: in the data sheet Equip # 111 - how many shifts did it work in April , then May

    There are several line descriptions for each date & shift worked
    Some work day & night shift - some only work days

    I would like a formula - Not sorting/filtering -( I can do that) but I am doing this all the time & would like a better more robust way to calculate.

    Thanks if you can help.
    Leigh

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