06-14-2022, 08:42 PM
Thank you everyone. I took a look at pivot tables and found the slicer. Pretty sweet. I track a lot of data for about 1500 students - and a lot of it changes daily. Some of the terms you have mentioned (SAS, R, VBA code) are all things I have seen in course descriptions but had no idea what they meant. (So it was hard to figure out what covered what I wanted to learn)
And I think you have a point Bjcheung77. That’s probably why I can get about halfway there with some things. I usually can get to a point where I have what I need but maybe not the *most* efficient way.
I am setting up formulas to do all the things that a pivot table could be doing for me.
And I think you have a point Bjcheung77. That’s probably why I can get about halfway there with some things. I usually can get to a point where I have what I need but maybe not the *most* efficient way.
I am setting up formulas to do all the things that a pivot table could be doing for me.