Thursday, July 6, 2017

yogi_Show In Sheet2 Results From Combining Data In Sheet1

Google Spreadsheet   Post  #2202
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-06-2017
question by Lalla Lilley:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/1KbbcqanNro;context-place=forum/docs
If same Name, combine data in Column B???
Here is my sample file:

https://docs.google.com/spreadsheets/d/1QZx4v5me_4HXMlqUYYw8kVm9BSWfDlMm8JYxvBE45a8/edit?usp=sharing


Here is what I'm trying to do :

Sometimes on a cruise there are several tips. Customer pays BEFORE cruise (Pre-Included Tip) and then decides they want to give them more at the end of the cruise.  

The Sample file shows how the csv file looks when this is done (Sheet 1 yellow).
I need code for a Sheet 2 that finds the "like" names and combines the total into one row of data.

I left the cell blank on Sheet 2 so that others can test code. I am hoping I shared it right this time and it allows editing.
If not, please let me know.

Thanks so much!
 L ~