With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, July 26, 2018
yogi_Query B27:C Where C=Value As Specified And Sort By B and C In Desc Order
I'm wondering if you could help. I'm trying to record procedures being done by multiple people. Ultimately, I want to get the total amount of each unique procedure each person has done. They will do different number of procedures each time (i.e. sometimes just one, sometimes 2, sometimes 5, etc.)
Here's an example of what I have set up
Each procedure could be either a, b, c, d or e.
Tom, Jerry, Mickey, and Minnie are the people performing the combinations of procedures.
I want to total automatically each specific procedure (a, b, c, d or e) regardless of which procedure column it falls in. In other words, I don't care if there are 3 "a"s in procedure 1 column and 2 "a"s in column 3. I just want a way to get to the total of 5 "a"s for Tom, Jerry, Mickey or Minnie.
Is there a better way to record the data rather than by creating 5 procedure columns? If not, then is there a way to get a count of unique procedures in all 5 columns?
This is somewhat difficult to explain, so I apologize if I'm not doing it well. Thanks for any help!