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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
572
Fluff
Fluff
M
  • Question Question
Count Max Open Trades by Date and Pair
Replies
1
Views
837
JamesCanale
JamesCanale
S
  • Solved
using advanced filter with 2 criteria one having a list & the other having text or no text
Replies
7
Views
844
RoryA
RoryA
N
  • Question Question
Split excel Data into separate Workbook rather then tabs.
Replies
2
Views
646
nihad
N
E
  • Solved
Creating tabulated data from a different worksheet
2
Replies
18
Views
978
Legacy 143009
L

Forum statistics

Threads
1,225,743
Messages
6,186,773
Members
453,370
Latest member
juliewar

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