So I have a spreadsheet that has values in B15, E15, H15, K15, N15, Q15, T15 and W15. The headings of these values are in a merged cell of B5 & C5 via text. So B5&C5 say "Springfield" for example and the value in their B15 cell is $79,000. Each value cell has a text heading.
How do I rank these cells from highest to lowest in a separate area of my spreadsheet that displays both the text and the value?
Capture.PNG
So it ranks and says on the side of the graph:
1. Albany 107,900
2. Glastonbury 94,975
3. Middlebury 91,098
4. Manchester 88,203
5. Springfield 79,877
6. Virginia Beach 64,418
7. Southbury 60,108
8. Brookfield 48,916
Thank you in advance.
Bookmarks