| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to create a sorting table with non numerical values
Basically I have some data which is organised like this :
-------------------------------------------------------------------------- Date | Q1 | Q2 | Q3 | Q4 | Q5 | -------------------------------------------------------------------------- 08/18 | Yes | No | Yes | No | Yes | -------------------------------------------------------------------------- 07/18 | No | Yes | No | No | No | -------------------------------------------------------------------------- 07/18 | Yes | Yes | Yes | No | Yes | -------------------------------------------------------------------------- 08/18 | Yes | No | No | Yes | No | -------------------------------------------------------------------------- I'd like to use maybe pivot table or something else to display the information like this : ------------------------------------------------------------------- | Q1 | Q2 | Q3 | Q4 | Q5 | -------------------------------------------------------------------------- Yes | 3 | 2 | 2 | 1 | 2 | -------------------------------------------------------------------------- No | 1 | 2 | 2 | 3 | 2 | -------------------------------------------------------------------------- and use the date a sorting mechanism to dynamically change the output How can I achieve this? Any tips or ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values in Pivot Table | Excel Discussion (Misc queries) | |||
| Automatic Sorting of Top Ten values in a table | Excel Discussion (Misc queries) | |||
| Pivot Table Import Link to Numerical Values | Excel Worksheet Functions | |||
| Sorting Numerical Values... | Excel Worksheet Functions | |||
| how do i create a pie chart in excel with non-numerical values? | Charts and Charting in Excel | |||
Threaded Mode
