Hi, hope you're doing great today.
In column B, I have # of events, like this:
<tbody>
</tbody>
In column C, I have Day number of week, eg:
<tbody>
</tbody>
In column D (if you want to use this instead of day number), I have the actual weekday name (eg TUE, etc).
Here's where I need your help, please:
I want to make a table (results in H2 thru N5), like this:
<tbody>
</tbody>
So, if possible, I'd like the formulas ideally, for my learning stage, that will go into H2 thru M5 for my output table.
Thank you very much for your help and time, which I truly value and appreciate. If can't do formulas I can try arrays, but I always forget when I go back into edit, and end up hitting Enter instead of CSE.
(oh, by "mode2", i mean 2nd most frequent occurrence from column B which is the data I'm hoping to analyze).
thank you so much!
In column B, I have # of events, like this:
2 |
1 |
1 |
2 |
1 |
4 |
<tbody>
</tbody>
In column C, I have Day number of week, eg:
1 (Sun) 2 3 4 (Wed) 5 6 7 (Sat) |
<tbody>
</tbody>
In column D (if you want to use this instead of day number), I have the actual weekday name (eg TUE, etc).
Here's where I need your help, please:
I want to make a table (results in H2 thru N5), like this:
MON | TUE | WED | TH | FR | SAT | SUN | |
AVERAGE # of events | |||||||
MODE1(most frequent event #) | |||||||
MODE2 (2nd most frequent event #) | |||||||
MEDIAN |
<tbody>
</tbody>
So, if possible, I'd like the formulas ideally, for my learning stage, that will go into H2 thru M5 for my output table.
Thank you very much for your help and time, which I truly value and appreciate. If can't do formulas I can try arrays, but I always forget when I go back into edit, and end up hitting Enter instead of CSE.
(oh, by "mode2", i mean 2nd most frequent occurrence from column B which is the data I'm hoping to analyze).
thank you so much!
Last edited: