Friday, April 20, 2018

yogi_Highlight Duplicate Entries In Column A

Google Spreadsheet   Post  #2430

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-20-2018
Hi,

Can anyone help to have the formulas for conditional formatting where all with same code in a column will be highlighted. Please with a sample sheet.

Thanks.



Tuesday, April 17, 2018

yogi_Rearrange Data of Events and Participants Into Table of Events By Participant And Gender

Google Spreadsheet   Post  #2429

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

question by: jpcsoccer
https://productforums.google.com/forum/#!topic/docs/SiaYzZt9CPI;context-place=forum/docs

I would like to list every row that a name appears in

 I have a spreadsheet to organize a track meet.  it goes
Event1  | name 1 | name 2
Event 2 | name 1 | name 3 | name 4
Event 3 | name 2 | name 5

I would like to produce this result
name 1 | Event 1 | Event 2
name 2 | Event 1 | Event 3
name 3 | Event 2
name 4 | Event 2
name 5 | Event 3

the sheet is attached.  would love some help!

yogi_Sort A Column Of Dates In M/D/YYYY Style By Day In Ascending Order

Google Spreadsheet   Post  #2428

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

question by: Sabrina3241
https://productforums.google.com/forum/#!topic/docs/P-F5jAm0waA;context-place=forum/docs
Sort by a column that has mm/dd/yyyy - chronological, not by first digit
My sheet keeps sorting the column by month, instead of mm/dd/yyyy. For example:

3/31/2019
3/31/2019
4/1/2018
4/11/2018
4/15/2019
4/15/2019
4/30/2019
5/1/2018
5/1/2018


I want it in chronological order by date, not by the first number. I cannot share the spreadsheet, but here is my formula:

=query(importrange("link", "Sheet1!A:AS"), "select Col4, Col18, Col19, Col20, Col21, Col22, Col25, Col26, Col27, Col39 where Col18 contains '1' or Col20 contains '1' or Col21 contains '1' or Col22 contains '1' order by Col39 asc format Col39 'mm/dd/yyyy'",0)

Monday, April 16, 2018

yogi_Rearrange Data of Events and Participants Into Table of Events By Participant

Google Spreadsheet   Post  #2427

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

question by: jpcsoccer
https://productforums.google.com/forum/#!topic/docs/SiaYzZt9CPI;context-place=forum/docs

I would like to list every row that a name appears in

 I have a spreadsheet to organize a track meet.  it goes
Event1  | name 1 | name 2
Event 2 | name 1 | name 3 | name 4
Event 3 | name 2 | name 5

I would like to produce this result
name 1 | Event 1 | Event 2
name 2 | Event 1 | Event 3
name 3 | Event 2
name 4 | Event 2
name 5 | Event 3

the sheet is attached.  would love some help!


yogi_Rearrange Row By Row Combined Entities In Column B By Date In Column A

Google Spreadsheet   Post  #2426

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-16-2018
I would like to join text from cells in B into a single cell but ONLY IF it matches a part

ADD A REPLY


Saturday, April 14, 2018

yogi_From A DropDown List Of Categories Choose Item Selected And Associated Product And Price

Google Spreadsheet   Post  #2425

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-14-2018
Hi can someone help me. I am trying to create a dependable drop down list in google sheets
For example, I have dropdown lists like the ones specified

Column A .  Column B  Column C . Column D
Apple            Fruit              Juice         $10
Tomato .       Vegetable      Salad        $15
Potato .         Vegetable .    Salad        $15
Chicken        Meat              Meal          $20
Beef              Meat              Meal          $18
Milk               Dairy             Drink          $6


What I would need is if I choose Tomato in column A, The drop down in column B should only show Vegetable Columns C should show only one value Salad and column D dropdown list will have only one value i.e. $15

Is this possible. If yes please help.

yogi_Create A Template For Reporting Data By Specified Month Beginning With Monday In Which First Of The Month Falls

Google Spreadsheet   Post  #2424

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-14-2018
How do you write a function as a range?
In Google Sheets, how do you create a variable range function?

I want to display a data set located somewhere else. So thought to use the INDEX function.
The problem is that I'm creating a template and thus the data set isn't always in the same place. So I thought to write the range for INDEX as an ADDRESS function and a MATCH function. However, no matter what I try I can't make it work.

An example [=index(address(match(J26,B:B),2,4):address(match(J26,B:B)+6,6,4))]

The problem seems to be that a function cannot serve as a variable. The INDEX function returns an error stating that the argument must be a range.

Is there a way to make this work or maybe a better way to get the same result?