How to extract most freq text from database on spec date only and display on other ws

D

dexter

New member
Joined
Sep 13, 2017
Messages
1
Reaction score
0
Points
0
Hi guy, from database, i need to summary what most activity John do for that day in other w/sheet. can help me.

John DatabaseSummary report
DateActivityDate1st Most freq Activity2nd Most freq Activity3rd Most freq Activity
1-JanEAT1-Jan
1-JanDRINK1-Feb
1-JanPLAY
1-JanSLEEP
1-JanSLEEP
1-JanSLEEP
1-JanPLAY
1-JanEAT
1-JanDRINK
1-FebEAT
1-FebEAT
1-FebPLAY
1-FebEAT
1-FebEAT
1-FebEAT
1-FebPLAY
1-FebSLEEP
thank in advance
 
You must log in or register to reply here.
Back
Top