[Solved] Finding the occurrence of multiple similar result

[mellie27]

Hi,

I've tried doing the following with Excel and it works but somehow over in OpenOffice I'm not able to generate the result. I need help.

I wish to auto tabulate Table 1 result to Table 2. In specific, I need to auto tabulate the corresponding Rest Days ("R") of each staff. To find the first R I have used the MATCH function. However I am unable to find the subsequent Rest Day(s). I wish to auto tabulate the figures highlighted in yellow.

i used index and small function in excel

{=iferror(INDEX(D3:AH3;SMALL(IF("R"=D4:AH4;COLUMN(D4:AH4)-COLUMN(D4)+1);2));"")}

but does not seem to be able to populate the result in OpenOffice

Thank you

[MrProgrammer]

I wish to auto tabulate Table 1 result to Table 2.

You want to filter the values from Table 1, using "R" was the selection criteria.
[Tutorial] Sorting and Filtering data with formulas

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[mellie27]

thanks. your tutorial helped!