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

D

Dexterk

New Member
Joined
Sep 13, 2017
Messages
1
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]
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

W
  • Solved
How many rows between each data point in a column
Replies
3
Views
558
Fluff
Fluff
M
  • Question Question
Count Max Open Trades by Date and Pair
Replies
1
Views
833
JamesCanale
JamesCanale
S
  • Solved
using advanced filter with 2 criteria one having a list & the other having text or no text
Replies
7
Views
832
RoryA
RoryA
N
  • Question Question
Split excel Data into separate Workbook rather then tabs.
Replies
2
Views
622
nihad
N
E
  • Solved
Creating tabulated data from a different worksheet
2
Replies
18
Views
963
Legacy 143009
L

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top