charlesfowler72
New Member
- Joined
- Aug 9, 2012
- Messages
- 37
Still fairly new at this, hopefully this will be simple enough for someone but I am having trouble setting the ranges. Below is the data.
<tbody>
</tbody>
So I am looking to sort with different layers, Firstly by day so Monday, Tuesday....N/A at the top. Then by Time 0900,1000,1100...N/A at the bottom.Then finally and most difficult by country with a customer list by US, EU, UK, CA.
I have tried recording by the range will be static but my table length varies day by day so it need to be A1:end. The final results would be as follows....
<tbody>
</tbody>
Any help would be incredible, thanks.
Day | Time | Co | Event |
Wednesday | 0900 | UK | X |
Tuesday | 0800 | US | X |
N/A | N/A | EU | X |
Tuesday | 0900 | US | X |
Tuesday | N/A | CA | X |
Tuesday | 1200 | EU | X |
Tuesday | 0800 | EU | X |
<tbody>
</tbody>
So I am looking to sort with different layers, Firstly by day so Monday, Tuesday....N/A at the top. Then by Time 0900,1000,1100...N/A at the bottom.Then finally and most difficult by country with a customer list by US, EU, UK, CA.
I have tried recording by the range will be static but my table length varies day by day so it need to be A1:end. The final results would be as follows....
Day | Time | Co | Event |
N/A | N/A | EU | X |
Tuesday | 0800 | US | X |
Tuesday | 0800 | EU | X |
Tuesday | 0900 | US | X |
Tuesday | 1200 | EU | X |
Tuesday | N/A | CA | X |
Wednesday | 0900 | UK | X |
<tbody>
</tbody>
Any help would be incredible, thanks.