Google Spreadsheet Post #2505
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Sep-03-2018
question by: Pamela Loveland
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Formula help with a Dynamic list with concatenate and sorting from an imported data rangeWe are starting to use Google Forms to let people sign in to our run club meets. It has a very simple first and last name text entry box, and that's it. I would like to keep a running calculation of how often someone has signed in on a separate sheet in the same workbook, keeping in mind that someone may sign up slightly different sometimes. So maybe I'm Pamela one day and Pam another day - I'd want them both to count. So I'm thinking that it needs grouped by last name on exact match, then on first with a SQL type 'like', ie: where firstname like 'Pam%' or something. Then it should count those entries in that group. I've no idea how to go about this in the spreadsheet the form exports to, plus it'd have to use the same formula all the way down the columns as more and more rows get added. Help?!
No comments:
Post a Comment