yogi_From All The Names in A Column Extract List Of Unique Names And The Corresponding Count Of Those names In The Column

                                          Google Spreadsheet   Post  #1354
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 02, 2013
user rajvivek (http://productforums.google.com/forum/?zx=fu1hfkvr8c2v#!mydiscussions/docs/9BbLm3KKiMY)
How do you list unique values of a list and count occurrences of each through a SINGLE formula?

Hi!

I have a set of names in column A3:A500, and many of them are duplicates... Is it possible to have a SINGLE formula (preferably QUERY one) that could both enlist unique names in Column B & no. of their occurrence in Column C without having to bother to add another formula or column in an already data-heavy spreadsheet?

I tried to use Pivot in Query but only got errors.

Thanks!

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

yogi_WorkAround (Convoluted) To Use GoogleFinance Function For An Array (for upto specified maximum number) Of Entries

                                          Google Spreadsheet   Post  #1243
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 16, 2013
user rajvivek (http://productforums.google.com/forum/?zx=j9xbgzjzha3t#!category-topic/docs/spreadsheets/BE1WrT2Zllo)
How to combine arrayformula with index?
Hi!

I am using this formula to know the exchange rate (closing) of a currency-pair of any particular date :  =INDEX(GoogleFinance("CURRENCY:USDINR";"close";A2) ; 2 ;2)

A2 = Date

How to re-imagine this formula to to include ArrayFormula so that the above formula does not need to be put in all the cells of B columns (by dragging or copy-pasting) as A column is full of dates and keep updating i.e., A2:A = Date ?

I tried this but it is not working : =ARRAYFORMULA(INDEX(GoogleFinance("CURRENCY:USDINR";"close";A2:A) ; 2 ;2))

The sample sheet is at this link : http://goo.gl/obJqV (Formula to be put in cell D2)

Thanks!

---

Yogi Anand's solution to somewhat similar problem at this post did the trick : https://productforums.google.com/forum/?fromgroups#!topic/docs/yVyfQZ1IHtY

Detailed solution for this problem at his (Yogi's) blog post here.

How to implement that solution into my problem is the real trick.

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