yogi_Query B27:C Where C=Value As Specified And Sort By B and C In Desc Order

Google Spreadsheet   Post  #2480

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-26-2018

question by: guyute
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/dA21oBp67f4;context-place=mydiscussions
How can I count totals of items multiple columns when the items overlap in each column?

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

	Procedure 1	Procedure 2	Procedure 3	Procedure 4	Procedure 5
Tom	a	a	b	c	d
Jerry	b	a	c	d	e
Mickey	e	b	c
Minnie	a

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!

yogi_Conditionally Format By Date Groups With A Blank Line Between Date Groups

Google Spreadsheet   Post  #2479

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-25-2018

question by: guyute
https://productforums.google.com/forum/#!topic/docs/9bJSSRpGbvY;context-place=forum/docs
How do I automatically sort by 3 sequential columns and add a colored dividing line?

I would like to automatically sort by 3 fields sequentially so that I don't have to highlight everything, then click data>sort range each time.

1. How can I have it automatically sort by multiple columns? First by date (column B), then by location (column I), then by time (column c)?

2. Also, I would like to have a colored line (bottom of rows 31, 32 and 39) dividing the different dates. If a colored line isn't possible, then an empty row.

Here is the link to the spreadsheet:

https://docs.google.com/spreadsheets/d/1PTMx97jvepEfuOxxrRHRjISHhE1w4ndGNlehFBTsMv0/edit?usp=sharing

The sheet is called "example 2 for totals"

The tab is called "autosort".

The top part of the table shows the data unsorted.

The lower part of the table shows it sorted with the horizontal line dividers in it.

THANK YOU!!

yogi_Multi-Criteria Count Problem 2

Google Spreadsheet   Post  #2473

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-08-2018

question by: guyute
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/dA21oBp67f4;context-place=mydiscussions

How can I count totals of items multiple columns when the items overlap in each column?

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

	Procedure 1	Procedure 2	Procedure 3	Procedure 4	Procedure 5
Tom	a	a	b	c	d
Jerry	b	a	c	d	e
Mickey	e	b	c
Minnie	a

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!

yogi_Multi-Criteria Count Problem

Google Spreadsheet   Post  #2467

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jun-30-2018

question by: guyute
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/dA21oBp67f4;context-place=mydiscussions

How can I count totals of items multiple columns when the items overlap in each column?

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

	Procedure 1	Procedure 2	Procedure 3	Procedure 4	Procedure 5
Tom	a	a	b	c	d
Jerry	b	a	c	d	e
Mickey	e	b	c
Minnie	a

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!