Results 1 to 10 of 10

Need list of unique values for sumiff'ed records

Threaded View

mys Scott Need list of unique values... 07-15-2011, 06:21 AM
NBVC Re: Need list of unique... 07-15-2011, 07:51 AM
Roger Govier Re: Need list of unique... 07-15-2011, 08:58 AM
mys Scott Re: Need list of unique... 07-25-2011, 04:27 PM
Roger Govier Re: Need list of unique... 07-27-2011, 05:41 AM
NBVC Re: Need list of unique... 07-25-2011, 10:41 PM
mys Scott Re: Need list of unique... 07-27-2011, 06:38 AM
mys Scott Re: Need list of unique... 07-27-2011, 06:49 AM
Roger Govier Re: Need list of unique... 07-27-2011, 07:55 AM
mys Scott Re: Need list of unique... 07-27-2011, 09:16 AM
  1. #4
    Registered User
    Join Date
    02-11-2011
    Location
    Annapolis, MD
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need list of unique values for sumiff'ed records

    Roger,
    That is great code, and it works perfectly in my sample sheet, so thank you very, very much. I thought I would be smart enough to apply whatever solution someone came up with to our real time tracking spreadsheet (attached), but once I read through your lines I began questioning my ability to accurately transpose it to our somewhat more complex sheet. The questions stem from not really being able to discern what were references to cells and what wasn't (I'm obviously not a programmer). Will the code you supplied work with the attached work book? The data entry is on the first sheet ALL DATA ENTRY with invoice #s in column M, task #s in column K, with the summary on the SUMMARY sheet. I've created the destination column (column L) for the invoice #s to be collected to on the sheet SUMMARY.
    Doable?
    With thanks for any further help (and great gratitude for the help so far),
    Scott
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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