Create a "sub-list" from a spreadsheet?

**Shodaar** · 09-30-2011, 07:37 AM

Hi all,

I have created a tracking sheet that will be used to track employees attendance of daily workshops. On a seperate worksheet, I want to create a dynamic filter that will allow me to filter the tracking sheet based on certain criteria of the attendees such as their language or supervisor.
I've managed to do it to a point but run into problems when there are multiple entries on the same date. The employee data has a unique employee ID number attached to them which I can use to distinguish one from the other but I can't figure out a formula to order them in the dynamic filter. I've tried arrays and various formulae such as LARGE, SMALL and RANK to try and sort them somehow that way but my brain has stopped working now and I can't think...
Could someone suggest the best formula to use here?

Thanks

**arlu1201** · 09-30-2011, 07:40 AM

Please attach a workbook as it will be easier to understand the problem.

**Shodaar** · 09-30-2011, 08:06 AM

Hi arlu1201,

Hopefully you can see this attachment. The first sheet is more or less what the tracking sheet looks like. The second sheet is what the Filter sheet will look like with the three filter options in yellow at the top.

does this make sense?

**brokenbiscuits** · 09-30-2011, 11:01 AM

I dunno what arlu thinks, but it doesn't make much sense to me. Can you explain further exactly what you are doing with the second sheet?

**arlu1201** · 09-30-2011, 11:03 AM

I wanted to review the problem with the spreadsheet in front of me. I will do so and revert in the next few mins.

**Shodaar** · 09-30-2011, 12:58 PM

Yeah, maybe I'm not explaining it very well, sorry.
Basically the first spread will be a tracking sheet that multiple users are entering in when empoyees attend these workshops.
On the second sheet, I want to have an option where the project leaders can filter people from the first worksheet. They should be able to filter (i.e. create a sub-set from the first worksheet) of the employees based on filters like their language skill or supervisor. So the filtered list would be a dynamic list that changes based on the filter chosen.

I realise I could just use filters from the first worksheet but I need the filtered list to be seperate from the tracking entries...