SOLVED

# Expanding Meals Count on each date

Frequent Contributor

# Expanding Meals Count on each date

Hi All

I have a set of data here down below in table 1. (Attached  the excel too)

I want to prepare Table 2 based on the date in table 1. ie., I want to expand the data from Table 1 based on from date to end date and meals count in these days (Breakfast, Lunch and Dinner).

Is there any particular formula/ power Queries to do this?

3 Replies
best response confirmed by Sameer_Kuppanath_Sultan (Frequent Contributor)
Solution

# Re: Expanding Meals Count on each date

See the attached version for a solution using formulas.

I also modified the formulas in Table 1 slightly.

# Re: Expanding Meals Count on each date

With everyone's permission, if I may add a simple formula in addition to the elegant solution proposed by Mr. Hans Vogelaar (@Hans Vogelaar).

=SUMIF(\$D\$3:\$D\$21,\$M3,\$H\$3:\$H\$21)+SUMIF(\$F\$3:\$F\$21,\$M3,\$H\$3:\$H\$21)

File is inserted.

If the simple suggested solution helps you, I'll be happy, if not please just ignore it :).

Thank you for your understanding and patience

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

Excellent!