Forum Discussion
Filter and Sort Output of Filter function
Hi,
I have a workbook, with the following table.
The purpose of the workbook is to send it to prospective clients for them to be able to filter project based on categories
| Mojo Consulting Company Projects | ||||
| ID | Project name | Project Duration (wks) | Cost | Categories |
| 2 | Springfield Power Station | 112 | $ 23,000,000 | A |
| 4 | Springfield Apartments | 108 | $ 11,000,000 | A |
| 8 | Townsville Apartments | 85 | $ 111,000,000 | B |
| 3 | Springfield Road | 83 | $ 80,000,000 | B , C |
| 1 | Springfield Dam | 65 | $ 77,000,000 | A, B, C |
| 6 | Townsville Power Station | 48 | $ 111,000,000 | A,D |
| 7 | Townsville Road | 27 | $ 103,000,000 | C |
| 5 | Townsville Dam | 10 | $ 41,000,000 | B |
I have been able to write a simple filter function for that, but I want the clients to be able to sort based on other fields, the usual way (with the sort and filter menu on the headers)
I know you can sort on the main table and have that reflect on the filter array, but the goal is to have the "filtered" table on sheet 1 , and have the data set on "sheet 2"
I have attached a sample workbook.
https://www.dropbox.com/s/zup1xwyzda7e08h/Mojo%20Consulting.xlsx?dl=0
bobkimani Like in the attached file? It would need a bit of refining, but I think this does what you meant.
14 Replies
bobkimani Perhaps like the attached file?
Riny_van_Eekelen Thanks, that's what I had in mind but wanted a filter/sort dropdowns to appear on one page, is there a way to do that. If not that's ok... I can tell my client it's not possible
bobkimani Sorry. Don't understand. You have the data in one sheet and the dropdowns and sorted and filtered data in another. Isn't that what you asked for?
