Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guy, from database, i need to summary what most activity John do for that day in other w/sheet. can help me.

    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
    thank in advance

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,170
    Articles
    0
    Hi and welcome
    try a Pivot Table
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •