Friday, May 27, 2016

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


Friday, May 20, 2016

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 :)



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


Saturday, May 7, 2016

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





Sunday, May 1, 2016

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
-------------------------------------------------------------------------------------------------------------------------------