lookup concatenate

I have a spreadsheet that lists gifts on a registry in one column. In another column, are potential names of the folks that bought the items. What i'd like to do is, use a lookup formula of some sort to find all the instances of a name (ex. "John Doe") and then combine all of the registry...

Hello. I have a table that keeps track of my debt payments. 3 of the columns are: Date, Payee, and Remaining Balance. I want to create another formula table or pivot table to see the Remaining Balance of each Payee by Month. I thought the following formula would work, but it's not...

I have to do lookup table. something like this if (a-b)>=75% then (a-b) * 25 and if (a-b)>-60% and less then then 74.9% then (a-b) * 15 I know its too complicated but any help will be appreciated. Thank you.

Hi I am trying to create a scoring spreadsheet for a childrens sport/fitness event but am having trouble with one of the formulas The results part is fine: It looks like this: (Note though that I have simplified it from over 400 competitors! and made up fake teams, names etc) The bit below works...