yogi_For Each Set Of Customer IDs Select Unique Product Names And Pull Associated Data

Google Spreadsheet   Post  #2156

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-01-2017

question by Jill Dub:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/I8EM7j-I8nE;context-place=mydiscussions
Generate Random List with Multiple Columns Required
I need to randomly generate a list, can be repeating, from a set number of entries - however I need to make sure that the other columns in the entry row also make it in which are data-sensitive. I need to generate the list from entries in Column B, but their corresponding rows in Columns A, C and D also need to be there.

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

yogi_Count Number OF Unique Drinks And Number Of Drinks By Person

Google Spreadsheet   Post  #2155

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-29-2017

question by epelj1:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ydLHdtDT-j4;context-place=forum/docs
Trying to 'rank' the most common used words in a range

I guess, while I'm at it, is there any way to Label the Col1 of that formula?

I'd appreciate any help! Thanks!

Test Sheet:

https://docs.google.com/spreadsheets/d/1Pa2UntDLeHrfV1KXiMD24TFt0cB_RM7fZwTSTEf4Srk/edit#gid=0

yogi_Compute Row By Row Sum Of Scores In Several Columns Per Poster's Specification

Google Spreadsheet   Post  #2154

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-22-2017

question by Brittany Manning:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/xKcapVNrkv0;context-place=mydiscussions
Formula to add cell values in a range BUT only add value up to 5
I have a sheet that I keep soccer scores on for district rankings.  One statistic that we must keep is "Goals Scored Maximum 5" and "Goals Against Maximum 5"  Is there a way to add the goals per game but only add the values up to 5 in each cell?  For example: 5, 9, 6, 1, and 3 would only add to 19 because anything over 5 is not added into the Sum.  I do not want it to omit the values if the cell reads greater than 5.

Please help! Thanks!

yogi_Generate Monthly reports From Data In Another Sheet

Google Spreadsheet   Post  #2153

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-13-2017

question by Paul Barley Chito:

https://productforums.google.com/forum/#!topic/docs/oFearzrrof0;context-place=forum/docs
Data Reporting with Additional Dates
Hi Guys,

I have data I wanted to generate reports.

1.) My problem is how can I do this automatically based on ranking.

2.) Second, report generation must be done monthly and so on.. E.g. If I encoded a new month, a new report for that month must be automatically created on a new column.

I attached my actual sheet.

Thank you in advance,

Paul

Database

Data

yogi_Compute Rate Of Pay Based On Position and Years

Google Spreadsheet   Post  #2152

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-13-2017

question by drdfoley:

https://productforums.google.com/forum/#!topic/docs/WPX4pFCL12E;context-place=forum/docs
Lookup value based on two criteria

I want to figure out the rate of pay for an employee based on the position and the number of years worked.  The first sheet has the employee's position and the number of years worked. The second sheet has a list of positions and the rate of pay based on the number of years worked.

I have tried a variety of formulas with no luck.  I am able to do the lookup based on the position but don't know how to get the rate of pay based on the number of years worked. Any help would be appreciated.

Thank you,

Dianna

Here is the sheet:

https://docs.google.com/spreadsheets/d/1o6l3zVG--trtg7j7LyWxczqc8r8lZVf6Op8JJ6Mtipo/edit?usp=sharing

yogi_Help With LookUp/Match and Split

Google Spreadsheet   Post  #2151

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-10-2017

question by giorobert88:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/UMjEdZqx5bU;context-place=mydiscussions
Help with lookup/match and split

Hi all,

I have been creating a spreadsheet which feeds directly from a Trello API.  One of the columns returns all of the tags for a given customer in a comma seperated list and I am looking for a way to look up the most recent and then only return the details to the right of the "unit:" tag before the next seperator (,). 

So far I have found a way to lookup the latest version:

=arrayformula(if(len(A2:A)=0,iferror(1/0),iferror(vlookup(A2:A,Log!B2:C,{1}*sign(row(A2:A)),FALSE))))

And a way to split:

=TRANSPOSE(SPLIT(JOIN("," , Log!C2:C), ",", FALSE))), 1, TRUE)

However, I am struggling to combine the 2, filter for only the data containing unit: and then return the data before the next comma. A copy of the spreadsheet can be found here:

https://docs.google.com/spreadsheets/d/14MSrBqZ9ye372_NFXUXgnBW9LJCbMatRVjHGUht12Uw/edit?usp=sharing

The log shows the raw output from the API. The Summary sheets shows the table I am trying to achieve. What I would like to return in cell B2:B4 is S5,S6,S5 therefore is looking up the latest activity per customer and returning the data following "Unit:" before the next , seperator.

Hopefully that makes sense. Any help would be much appreciated.

Thanks in advance.

yogi_Count Number By WeekDay For WeekDays Listed In Column F

Google Spreadsheet   Post  #2150

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-09-2017

question by Cyndy Hopper:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/4MqXIv_xRyY;context-place=forum/docs

HELP needed with formula

I have a column that contains data like

               Monday, Tuesday, Wednesday, Thursday, Friday

               Monday, Wednesday, Friday

               Tuesday, Thursday, Friday

               Wednesday, Thursday, Friday

               Tuesday, Wednesday, Thursday

I would like to count the number of Mondays             (2)

                              the number of Tuesdays            (3)

                              the number of Wednesdays       (4)

                              the number of Thursdays           (4)

                              the number of Fridays               (4)

HELP......... as you can see I'm not a big formula user - but need for this spreadsheet

Thanks !