Results 1 to 10 of 10

show unique locations or account # by month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,228

    show unique locations or account # by month

    I have a list of accounts ~6500 rows of data.

    it shows accounts listed by "account # - column D" and "address - column F".

    I require a formula (not pivot table) In cell Z2 i want to show "unique" list of locations by EACH MONTH that occur only once, so i can calculate their revenue. For example, ABC Inc may be serviced 3 times in a month, however i want to show the value for the "first" service that occured for that month.

    THerefore, my criterias are
    Month = column S
    Category = "auto" column T
    Unique address = column F or use column D (account #)

    i have been stuck on this and dont know where to go. any help will be truly appreciated....thanking you in advance.
    Attached Files Attached Files
    Last edited by jw01; 05-31-2013 at 01:57 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