Hello All, 1st Post!!
I Have a data set with multiple tables that are each formatted for dates, a name and a count function, all pulled from access. Below is an example of a portion of one table.
<tbody>
</tbody>
<tbody>
</tbody>In a separate tab I'd like to create a table that pulls the largest count number for a specific date (cell reference) and then in a separate column the corresponding name and then repeating for the 2nd largest value and so on. Could anyone please advise? I am trying to avoid adding helper columns that ranks the count. Please let me know if additional details are needed.
I Have a data set with multiple tables that are each formatted for dates, a name and a count function, all pulled from access. Below is an example of a portion of one table.
5/22/2015 | HP | 3 |
5/22/2015 | Blue Line Drilling | 2 |
5/22/2015 | TDG.cn | 1 |
5/22/2015 | Ruff Drilling | 1 |
5/22/2015 | MCG Drilling & Completing | 1 |
5/22/2015 | J-W Energy Company | 1 |
5/22/2015 | Felderhoff Brothers Drilling | 1 |
5/22/2015 | Double K Drilling | 1 |
5/15/2015 | TDG.cn | 1 |
5/15/2015 | Ruff Drilling | 1 |
5/15/2015 | MCG Drilling & Completing | 1 |
5/15/2015 | J-W Energy Company | 1 |
<tbody>
</tbody>
<tbody>
</tbody>