I have daily entries which range from once to as many as 6 per day. I would like group the daily entries into 4 groups, rising, morning, afternoon, and evening and then transfer all daily entries into a single row per day with columns for each group. Some days will have no entries, some with one and some with up to 6. Within each group, if there are more than one entry I would like to transfer only the maximum. I have taken the basic entries and grouped into the 4 ranges. A sample is provided below. Column A has the daily entries and B-E are the daily groups. Column F will be the daily record and G-J the consolidated groups for each day.Thanks for your help!
Bookmarks