How to extract feq text by date, from huge data.

[Dexterk]

Hi guy, i just need to summary their activity by most feq and date, already try index, mode, match but cat filter up by date, help me please.

John Database		Summary report
Date	Activity		Date	1st Most freq Activity	2nd Most freq Activity	3rd Most freq Activity
1-Jan	EAT		1-Jan
1-Jan	DRINK		1-Feb
1-Jan	PLAY
1-Jan	SLEEP
1-Jan	SLEEP
1-Jan	SLEEP
1-Jan	PLAY
1-Jan	EAT
1-Jan	DRINK
1-Feb	EAT
1-Feb	EAT
1-Feb	PLAY
1-Feb	EAT
1-Feb	EAT
1-Feb	EAT
1-Feb	PLAY
1-Feb	SLEEP

<colgroup><col width="88"><col width="77"><col width="64"><col width="83"><col width="167"><col width="64"><col width="64"></colgroup><tbody>
</tbody>

 

[SteveO59L]

have you considered a pivot table?