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, July 14, 2013
yogi_Set Up Computed Columns In A Response Table To LookUp Pairs Per User Spec
Looking for a more efficient and elegant formula to look up a pair
I have a large spreadsheet with registrations of over 500 participants for a conference. The dataset (created from form postings) contains 48 columns of data for each participant.
We've added three columns to the spreadsheet
One (AW) contains a manually entered "Companionship" number (eg. M1, M2, F1, F2 and so forth).
A second one (AX) is a "helper" column which merely counts the instances of the companionship number in the data and appends that number to the end of the Companionship number. =AW2&countif($AW$2:AW2,AW2)
The third one (AZ) performs a lookup in the dataset for the matching Companionship and enters a companion.