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.

[TABLE="width: 607"]
<colgroup><col width="88"><col width="77"><col width="64"><col width="83"><col width="167"><col width="64"><col width="64"></colgroup><tbody>[TR]
[TD="class: et2, width: 176, colspan: 2, align: center"]John Database[/TD]
[TD][/TD]
[TD="class: et2, width: 397, colspan: 4, align: center"]Summary report[/TD]
[/TR]
[TR]
[TD="class: et3, width: 88, align: center"]Date[/TD]
[TD="class: et3, width: 77, align: center"]Activity[/TD]
[TD][/TD]
[TD="class: et2, width: 83, align: center"]Date[/TD]
[TD="class: et2, width: 167, align: center"]1st Most freq Activity[/TD]
[TD="class: et2, width: 64, align: center"]2nd Most freq Activity[/TD]
[TD="class: et2, width: 64, align: center"]3rd Most freq Activity[/TD]
[/TR]
[TR]
[TD="class: et4, width: 88, align: center"]1-Jan[/TD]
[TD="class: et5, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD="class: et6, width: 83, align: center"]1-Jan[/TD]
[TD="class: et7, width: 167"][/TD]
[TD="class: et7, width: 64"][/TD]
[TD="class: et7, width: 64"][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]DRINK[/TD]
[TD][/TD]
[TD="class: et6, width: 83, align: center"]1-Feb[/TD]
[TD="class: et7, width: 167"][/TD]
[TD="class: et7, width: 64"][/TD]
[TD="class: et7, width: 64"][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]PLAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]SLEEP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]SLEEP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]SLEEP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]PLAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Jan[/TD]
[TD="class: et9, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et10, width: 88, align: center"]1-Jan[/TD]
[TD="class: et11, width: 77, align: center"]DRINK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et4, width: 88, align: center"]1-Feb[/TD]
[TD="class: et5, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]PLAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]EAT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et8, width: 88, align: center"]1-Feb[/TD]
[TD="class: et9, width: 77, align: center"]PLAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: et10, width: 88, align: center"]1-Feb[/TD]
[TD="class: et11, width: 77, align: center"]SLEEP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[SteveO59L]

have you considered a pivot table?