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
Bookmarks