Apr 01 2020 09:08 AM
Hi All, I'm new to this so just throwng looking for advice.
If i have a table i want to sort via clicing on watver cell i click, how do i do this?
For example if my table was as below i want ti click Contract type and the table sort a-z below, if i click again it would sort z-a. If i thin click 2020 Quarterly Charge it would display lowest to highest value below and clicked again it would return highest to lowest order . I've seen these tables on line with an up/down arrow sign but can't find on Excel so maybe it's Microsoft Access platform or something. any help would be greatly appreciated! B
Contract Type | Development | 2020 Quarterly Charge | Q1 AFS CALC |
Fire Alarm and Emergency Lighting | Achill Square | €233.97 | €198.90 |
Fire Alarm and Emergency Lighting | Adamstown | €920.00 | €876.35 |
Fire Alarm and Emergency Lighting | Allendale | €135.00 | €106.96 |
Emergency Lights only | CNML Block 1 | €250.00 | €168.25 |
Apr 01 2020 09:46 AM
Here's a resource that should answer your question. https://exceljet.net/lessons/how-to-sort-an-excel-table
Apr 01 2020 10:21 AM - edited Apr 01 2020 10:24 AM
Apr 01 2020 12:11 PM
Apr 01 2020 12:11 PM
Apr 01 2020 02:00 PM
Do you have reason to believe that's an Excel screen shot?
It might be, I suppose, but I've never seen that pairing of arrows in the headings of an Excel Table...
If it is, and you do find out how to do it , please come back and share the news.