Showing posts with label Cloud Computing post by TN Dispatch. Show all posts
Showing posts with label Cloud Computing post by TN Dispatch. Show all posts

Wednesday, January 14, 2015

yogi_Conditionallty Format Rows If Same Date (column B) And Name (column D) Occur More Than Two Times

             Google Spreadsheet   Post  #1882
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2015
post by  TN Dispatch:
https://productforums.google.com/forum/#!mydiscussions/docs/O-qBgP_njDU
how to color a row of cells if a value occurs more then twice
I am looking for a script or formula that will color coat a row if a value occurs more then once on the same date. I have attatched the sheet for reference. If you notice column b has dates c has company names and d has names i would like if adam with tn transport has more then 2 entrys on the 6th then those rows are colored orange with blue text. 

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

Wednesday, December 17, 2014

yogi_Sort Entries By An Attribute That Occurs Most Often

             Google Spreadsheet   Post  #1865
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-17-2014
post by  GregCu:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/7yvIYNMr-E0
how to sort based on the number of times something occurs
I am trying to sort a set of data bassed on how many times a name occurs ex-

Bill   1234
Bill   1333
Joe   1221
greg   1222
greg   1545
greg    1546

so when the sort is finished the data will display like so

greg   1222
greg   1545
greg    1546
Bill   1234
Bill   1333
Joe   1221
------------------------------------------------------------------------------------