yogi_Given A Table Of Contacts Split Entries Into 'FirstName' 'Spouse FirstName' 'LastName'

Google Spreadsheet   Post  #2066

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

question by: R123R123:

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

Split Couple and Single Names from same column

Hi, I have a large sheet consisting of names similar to as seen below, both married couples with the format "(Husband) and (Wife) Last Name" as well as single individuals "First Last". How can I split the married and single names up so that I achieve the desired outcome attached below?

Thank you!

Screen Shot 2016-05-27 at 1.57.33 PM.png

14 KB

yogi_Compute Number Of Rows That Have 0 and Frog In The Same Row In Range D8:H14

Google Spreadsheet   Post  #2065

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

question by: Shaun Milliken:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/_GXPt1R0k6w;context-place=mydiscussions
question by: Shaun Milliken
Google Sheets Formula for Counting Rows Once That Have Duplicate Entries

I have searched for weeks to a solution to my problem but have found nothing helpful.  I have included a link to a sample spreadsheet that describes the problem I am trying to solve.  

I am trying to count how many rows in a spreadsheet have a zero and a specific word.  The problem is that the word is present multiple times in some rows so those particular rows are counted multiple times in the total instead of only once.  My linked spreadsheet below explains it much better with data and examples.

Thank you in advance for any help offered as I have been trying to solve this for far too long :)

Sample Spreadsheet

---------------------------------------------------------------------------------------------------------

yogi_Compute Dates In Cell A2 And Down That Are Before Date In Cell A1 Skipping Weekends

Google Spreadsheet   Post  #2064

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

question by: Enzo Jonica:

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

how to change date order ????

hi  i need some help  i  want   to show a date  like  this  when i enter   say  5/6/2016   then i would like  the  order to be

5/5/2016

5/4/2016

5/3/2016

see  picture  don't know  how to change  the  order  when i enter the first  date  then the  order  come like the picture  how  can i invert the order  thanks very much 

excel google help.png

13 KB

---------------------------------------------skip the weekends Sat and Sun

yogi_For Domains In Column A Of Sheet2 Assign Highest Rating Based On 'Best' 'Good' 'Bad' From Data In Table Of Sheet1

Google Spreadsheet   Post  #2063

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

question by: agalaga:

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

Vlookup with wildcard to return highest value?

 On sheet1 - column A I have a list of URLs. In column B I have a quality rating. 

On sheet2 - column A I have domains. In column B I have the highest "quality rating". It goes from "best", "good", "bad"

On sheet2 - A2, if I type "forbes.com" I need B2 to return the "Best". If I type "businessinsider.com" in A3, I need B3 to return "Good".

I not sure how to get B2 to return the top quality rating. I've tried a number of nested if statements, vlookup, index, search and other functions but still can't figure it out.

Sheet for reference for reference:
https://docs.google.com/spreadsheets/d/1EK6svhHswWG46x8jnqXIPn0Okyv2f29m8_6DuBGjeZs/edit?usp=sharing

Thank you

-------------------------------------------------------------------------------------------------------------------------------

yogi_Assign Numeric Value To Text Attributes And Sum Up Row By Row Score From Different Sheets

Google Spreadsheet   Post  #2062

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

question by: Tanya Peters:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ifnR-TeRkmk;context-place=forum/docs
Data Validation - Assign Value for text
I am needing to assign a value to some text that we are using to score a person from 1 to 3 for our application process. Can anyone help on how this should be done as we have 3 sheets we are compiling into a main dashboard to pick our top candidates.

I also would like to have the candidates on the main page and have them compile into each of the 3 sheets so we are always the same across the board.

Here is a link to the spreadsheet we are working on.

https://docs.google.com/spreadsheets/d/1UxefAXt6rZj-0IaWaPzlhSasnLV4zXk-qU2SqyqB0Jc/edit?usp=sharing

Hope this makes sense.

--------------------------------------------------------------------------------------------------------

yogi_From Data In 'Form responses' Sheet Compute Stats By Day_Of_Week Week_To_Date Month_To_Date Year_To_Date

Google Spreadsheet   Post  #2061

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

question by: zohair92:

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

Form Responses Sheet (From a Google Form) ->Organizing Into Periodical Tabs (Weekly...etc)

 Hello all, 

I have a Google Form which tracks three kinds of warranties sold by my employees. 

Naturally, the responses to the form go to a Google Doc Sheet. The Form tracks the following information: The date/time, the employee name, and the warranty sold. What I would like to do is have a tab for Daily results (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday), a tab for Week to Date Results, a tab for Month to Date Results, and a Tab for Year to Date results.  

Essentially, I'm wondering if there is a way to automatically filter the raw data by using a calendar format? So I would like the current week to be displayed in the Daily Results Tabs.  In the Week To Date tab, I would like it to tally up the results for the week based on the day of the week (so if its wednesday, tally up monday+tuesday+wednesday). Sort of a live tracking system. 

I know it sounds complicated, so I've uploaded a sheet as an example of what I want to see. 

Please ive been struggling with this. If you need more information please let me know!

Thank you!!

Zohair

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

---------------------------------------------------------------------------------------------------

yogi_Custom Sort Data In Columns E2:H To match The Order Of Entries In Columns A2:A

Google Spreadsheet   Post  #2060

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

question by: sc456a:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/N-xhnmvBLyE;context-place=forum/docs

Matching two sets of data by columns

Here's an example:

word1	301000	0.18	$1.54	word3	US	0.69	880
word2	246000	0.34	$3.07	word2	US	0.44	880
word3	165000	0.16	$1.36	word1	US	0.64	390

What I'd like to do is sort the right four columns to match the order found in the left four, based on the keywords matching. Word1 would then be at the top, followed by word2, etc, with the data in the far right three columns resorted as well, for an end result like so:

word1	301000	0.18	$1.54	word1	US	0.64	390
word2	246000	0.34	$3.07	word2	US	0.44	880
word3	165000	0.16	$1.36	word3	US	0.69	880

Any help would be appreciated!