Narayan,
Thanks for the reference to the downloadable spreadsheet!! I was able to figure out the examples contained on it, determine which one was most appropriate for my needs, and modify that formula for my spreadsheet. I may not yet understand every aspect of the formula I created, but it's...
Luke,
Thanks for the quick reply!
I saw Vijay's solution but couldn't get the range and cell references correct when I tried to use the formula in my worksheet (my source data is on a different tab from my results table, which likely added to my confusion). I've provided the column headings...
1st, thanks for having this forum. I've been working in Excel for years, but not at this level, so having access to your help is greatly appreciated!
2nd, let me see if I can explain this clearly. I have a workbook with 5 tabs, one of which is a list of my Master survey data that has 3 data...