+ Reply to Thread
Results 1 to 2 of 2

Help with analysing a list of repeating codes with values greater than -1??????

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011, mac
    Posts
    45

    Help with analysing a list of repeating codes with values greater than -1??????

    Hi there,

    i am using Excel 2011 on a mac and really need some help. i have a selection of data that lists a repeating code (say group 1, group 2, group 3 etc)and a value (-1,-2.3,3,6 etc) and need to find a quick way group together all the codes and next to that a value that counts how many values who share the same code hold a value greater than -1? I can do this myself in a pivot chat with count totals but my issue is how I can show the number of codes greater than -1. Any step by step help fully appreciated, i cant work it out so annoying. Attached is an example of the data I want to sort.

    example of data that needs sorting.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Help with analysing a list of repeating codes with values greater than -1??????

    Hi and welcome to the forum

    Not sure is this is what you are looking for, but use this, copied down, to count unique entries >0....
    =IF(A5=A4,"",COUNTIFS($B$5:$B$173,">1",$A$5:$A$173,A5))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

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