Hi all,
I have a rather complex sheet (table) from which I'd like to extract data to create statistics. Please see attached file. Sheet labeled "Source" is the original. I'm particularly interested in Swing 1, 2, 3, ...etc. Time 1,2,3,... etc. is also of interest, but not a priority. Maybe the final solution for Swings can be used for that one also...
I've been gathering statistics on this by copy and pasting manually, but I find that in the end it's too time consuming, so I need to find a better way to accomplish this. Ultimately, I'd want to create bins of various sizes and make a frequency count/histograms.
I don't completely envision how the end result would be, but, I imagine if I could somehow create a list/column(s) containing all these cell values, I could use that to make a count. One problem is that I might want to isolate this day-by-day. Also, every row have a different # of swings, making this task even harder.
Any ideas at all?
The first step I did on my own was to create a linked sheet which simply extracts the data of interest (Swings). Maybe something workable can be done from there...
PS: It would also be great if lookback period can be user-defined, i.e., last 20 days or entire sheet. I've set up something similar in other sheets when doing counts by simply using the OFFSET function.
Thanks in advance for all and any help!
Elijah
Bookmarks