Hi Everyone! Since Microsoft took away the "Rank Order" function within pivot tables 2016 for Mac i have been having difficulty finding a way to rank the following data based on unique incident number and date/time values.
Column A Column B Column C
12345 5/1/2015 20:20:12 1
12345 5/1/2015 21:12:08 2
12346 6/4/2015 17:12:34 1
12347 7/1:2015 12:00:01 1
12348 7/10/2015 07:07:12 1
12348 7/10/2015 07:07:12 1
12348 7/10/2015 07:20:12 2
12349 7/10/2015 07:30:45 1
First I need the incident number in column A to be matched than column B Date/Time values ranked with like values receiving a 1 ranking. Thank you everyone.
Bookmarks