With the use of a MS Excel formula, I would like to rank data using the Total Number of Times (occurrences/incidences) a word is found against the Total Number of All Words.
EXAMPLE: (Name | Occurrences | Total Population)
John | 101,215 | 320,000,000
I would like to know with the provided data sample, if there's a way to derive to a RANK NUMBER AND RANK PERCENTAGE that outputs where the name John would rank against the Total Population. And, the output will be located in Column D2 (Rank Percentage) and/or E2 (Rank Number)?
Comments
Post a Comment