With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, April 14, 2013
yogi_In A Table of Multiple IDs And Dates Pull Unique IDs And Transpose The Corresponding Dates For Each ID
Working with a list of id's. If an id comes up more than once I want to transpose. I have 2 separate formulas 1) finds the ids and puts them in a list and 2) finds the dates and kind of transposes them.
I want to combine these to make 1 array (?) formula that can do both. I filled both formulas with colors on the test sheet.