## Can you split “The Hangover” expenses? [Excel Homework]

One of my all time favorite comedies is The Hangover. It is the story of four friends – Alan, Stu, Doug & Phil going to Las Vegas for an (un)forgettable night of adventure and mayhem. While the movie did end on a happy note, they forgot one little thing.

They didn’t share the expenses!

So in this installment of Excel Homework, can you split the expenses?

## The Problem

Assuming you have below data (feel free to copy paste it in to your Excel, or use this workbook):

```				```
Expense Details
Phil: 255.12,121.29,160.23
Alan: 43.17,226.76,343.66,358.01
Phil: 159.95,177.56,278.37
Stu: 206.51,188.09,244.68,33.21,152.98
Phil: 285.91,306.4,140.68
Doug: 226.76,226.76,169.6,208.67
Phil: 326.4
Phil: 308.43,224.95,102.33
Phil: 168.64
Stu: 259.93
Stu: 121.29
Stu: 177
Alan: 172.23
Alan: 214.04,162.58,205.66,188.16,128.41
Alan: 62.75,160.51,173.34,283.8
Phil: 356.3,361.34,41.35,255.94,67.42
Stu: 168.25,161.28,248.45
Doug: 163.93,308.43,218.58
Phil: 226.04,265.97,140.81,197.45
Doug: 216.79,180.39,246.65,149.55

```
```

Your need to generate a a table like this to show who needs to pay whom & how much.

Get cracking then!

## Sample file & Your Solution:

You can use any Excel feature to come up with the answer.

Tell me how you solved it using the comments box below

## Watch my solution:

I made a video about this problem and one approach to solve it (using Power Query and Dynamic Array Formulas). Check it out below or on my Channel.

## More homework problems:

Need a challenge? I got one or many for you:

• Write a formula for department monthly budget
• Can you find the secret code in the data?
• Can you match the job titles?
• More homework problems

The post Can you split “The Hangover” expenses? [Excel Homework] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Original source: https://chandoo.org/wp/the-hangover-expense-problem/