yogi_Compute The Most Occurring Skill In Column C

                                          Google Spreadsheet   Post  #1445
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-24, 2013
question by JFC1111 (https://productforums.google.com/forum/#!category-topic/docs/LLIdbz8KZvk)
Mode for text string using the New Google Sheets?

Is there a new way to solve this problem outlined in this old post?

http://productforums.google.com/d/msg/docs/St1a3aXzHbU/g3k3MnQETl8J

Thanks

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

The following solution using Google New Sheets uses all the features that are also available in the other version of Google Sheets as well ... so there is nothing particularly unique about using this in Google New Sheets

yogi_Dynamically Highlight Duplicate Entries in Column A Across All Tabs (Sheet1 Sheet2 Sheet3) Of A Spreadsheet

                                          Google Spreadsheet   Post  #1444
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-24, 2013
question by 13245DM (http://productforums.google.com/forum/?zx=fvgkvgqvpzi3#!mydiscussions/docs/6RUZSlMx3nI)
Find duplicates in across multiple sheets and locate and highlight duplicate

Hello,

I have provided a link to my sample sheet.

https://docs.google.com/a/fugal.com/spreadsheet/ccc?key=0Apur2TIv2WbtdDJ0S3plUDdQZURTenVYcjlTd0RwSWc&usp=drive_web#gid=0

My objective is to avoid any duplicates in column A, across all tabs. If there are any duplicates, I would like to see an error message (like data validation in excel using a customer formula). 

I would also like to highlight any duplicate address.

Any help with this would be great!!!!

Thanks

-----------------------------------------------------------------------------------------------------------------------
I have used Google's New Sheets made available in the second week of December 2013 because it allows formula based Conditional Formatting.

yogi_Count Instances Of Each Option From Comma Separated Values In Column A

                                          Google Spreadsheet   Post  #1443
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-24, 2013
question by Ramunas Kulvelis (http://productforums.google.com/forum/?zx=f7xjnk7yqcml#!category-topic/docs/spreadsheets/UQlnpEOgBGo)
Having difficulty in using countif
Hello,

I'm having issue in utilizing COUNTIF. I use it to get the count of data that meets the criteria. 

https://docs.google.com/spreadsheet/pub?key=0AnZThc8kqc3vdElydVo2bEhEZzZJd0JsMU5YSzhmaWc&single=true&gid=2&output=html

Posted a link with sheet with test data. As you can see there are cells that have data separated with commas, this is the format in what I get data from google form. COUNTIF ignores it and passes check over to next cell below, which holds only one number. The forluma I'm using is =COUNTIF($A$16:$A$24;"="&A4). Is there a way to make formula to not ignore cells with multiply data separated with commas.

Thank you. 
-------------------------------------------------------------------------------------------------------------------------

yogi_Compute Quantities Ordered By Product Number And Color Given The Order Number

                                          Google Spreadsheet   Post  #1442
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-23, 2013
question by Villu (https://productforums.google.com/forum/#!topicsearchin/docs/after$3A2013$2F11$2F30$20AND$20-is$3Aduplicate$20AND$20-is$3Aanswered$20AND$20-is$3Aresponded$20AND$20-is$3Acanbeignored%7Csort:date%7Cspell:true/docs/qR6wF92Xr4I)
how to sum values that meet 3 criteria

Hi

I need some help with my spreadseet. I have a table of product orders where every order has unique order number, order date, order deadline, client name, status of order and product info. Product info consists of product name, color and quantity. There are 18 different combinations of products and colors (6 products and 3 colors).

I use data validation to enter client name, product name and color to avoid typos.

I other table I have the summary of orders where I have entered all the combinations of products and colors and need to know how many of these combinations has been ordered. For example, how many Red Product 1 has been ordered by all clients in total. I tried index and match, but it gives me the first match as result and does not sum the matches.

In addition to that I have a table for summary of one order (order sheet). There I need to find quantities of all product name and color combinations that match order number.

I hope my description of a problem is understandable and someone can help me.

Thank you in advance,

Villu

---

Here is a link to sample file https://docs.google.com/spreadsheet/ccc?key=0Ak6Iv35slXpldFhQcUdUanJrY29DNkVGamNBajV2VVE#gid=0

Villu

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

yogi_Compute Sum Of Amounts Based On Multiple Criteria In Multiple Columns

                                          Google Spreadsheet   Post  #1441
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-22, 2013
question by Slava Ross (https://productforums.google.com/forum/#!mydiscussions/docs/1rAYfMroWE8)
Multiple Criteria in Multiple Columns Formula Please Help.

Hi would love some help on the sheet that I'm doing

https://docs.google.com/spreadsheet/ccc?key=0AlJ6lDNx-7PpdG13eEgzYWJ0aS05MUU3MUJOdnh3QlE#gid=1

basically I want Column H Added in a random cell that meets D(Groceries, Gifts) and Column G(Free Flow). But if Column D and G have criteria met at the same time it still only adds once.

Any help appreciated been on int for over 4h. Can't figure it out.

---

What mreighties was saying is correct.

4:45 PM (6 hours ago)

If I understand correctly, Slava wants to just add the total "Gifts/Free Flow", but not to include the total "Groceries/Free Flow".

D                     G                      H

1 Gifts            Free Flow               $100

2 Groceries        Free Flow               $100

3 Gifts            Active Funds            $100

4 Groceries        Active Funds            $100

5 Gifts            Passive Funds           $100

6 Gas              Active Funds            $100

7 Gas              Free Flow               $100

The formula would add amounts in H together. So in my example it would total to $600. 

It will not calculate row 1,2 twice because it has Gifts and Free flow or Groceries and Free flow in one row.

thank you guys for your time and helping me

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

yogi_Extract Numeric Grade from Letter Grade Given A=4 B=3 C=2 D=1 F=0

yogi_Compute Jerry Seinfeld Chain From A Set Of Current Streaks

                                          Google Spreadsheet   Post  #1440
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-15, 2013
question by Josiah Sprague (http://productforums.google.com/forum/?zx=2prcm5ppprxr#!mydiscussions/docs/wBleMdlhsWM)
Formula for calculating a running average of streak length
I'm using Jerry Seinfeld's chain method to track habits that I want to change. I want to track my chains in a Spreadsheet and have a running average of my chain length. I want to be able to say something like, "On average, over the last six months, the length of my 'winning streaks' has gone up/down".

I have a vague idea of how to set this up, but I am not quite there. I've got one column for date, another column for the current streak length on each day, and I'm trying to come up with a third column that will generate a running average of my streak lengths over a certain time period (say 6 months). Eventually I would like to graph this information too, so that I can see how my average streak length is changing on a daily basis. I'm at a loss for which formula to use, or perhaps I need to tweak my model a little bit to get the information I am looking for.

Any help would be greatly appreciated!

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