List All Rows in Database which Belong to X Employee

[AndrewDrewAndy]

Hello,

I have a timesheet database which has a row for every period an employee has clocked in during a pay period (typically 30x per period). On another worksheet, I have a summary by employee (grouped every 50 rows). I've written the below formula and have successfully output the data. However I am running into the below issues and would like to see if there is a way to optimize the formula.

Issues:
1) Every time I F9 the workbook the Calculating (12 Threads) takes >1 minute
2) My outputs are every 50 rows so when I paste formulas down I have to adjusted the "ROW(1:1) etc.

Formula: =IFERROR(INDEX('Expanded Report'!$C:$M,SMALL(IF('Expanded Report'!$C:$C='Calculator'!$C$6,ROW('Expanded Report'!$C:$C)),ROW(1:1)),2),"")

Expanded Report = timesheet database
'Calculator'!$C$6 = Employee Name (this become $C$56, $C$156, etc.)

Thank you for any insights.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Clear all cells of the existing formula & enter this in a single cell

=FILTER('Expanded Report'!$C$2:$M$10000,'Expanded Report'!$C$2:$C$10000=C6,"")

 

[AndrewDrewAndy]

Thank you, Fluff. This is exactly what I needed

 

[Fluff]

You're welcome & thanks for the feedback.