I have some Excel data that looks a bit like this:
John / Tim Upheld Sam Upheld Tim / Dave Upheld Sam / John Not Upheld Tim Not Upheld Dave / Tim Upheld
How can I do the following in Excel, if I can at all?
- Count each unique name separated by slashes in column A, and rank them by order of occurences (so Tim, Dave, Sam, John).
- Count the number of times each unique name appears with 'Upheld' in column B (so Tim, Dave, John, Sam).
Would this perhaps be better done using a Python script, or similar?