Can anyone explain this or break it down for me?

G

guybrown

Board Regular
Joined
Jul 2, 2008
Messages
100
=SUBSTITUTE(Aconcat(IF(MMULT(IF(ISTEXT(OFFSET($B$2:$D$2,A17,0)),IF(ISTEXT(TRANSPOSE($G$9:$K$11)),1,0),0),{1;1;1})>0,", "&TRANSPOSE($G$8:$K$8),"")),", ","",1)&"."
 
Sort by date Sort by votes

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
guybrown said:
pgc01

That works well thanks - nice to find a different way of doing this...
Would there be a way to adapt that formula to exclude duplicates and put a comma and space between each phrase?

Guy
Click to expand...

Hi Guy

Can you post some examples using the format you used in post #3?

Please post in the 3rd table (Drinks consumed by Day) the outputs you get from the formula and, to the right, the outputs you'd like.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
How to independently sort multiple columns of this SEQUENCE output without effecting the positions of the columns and of the blanks?
2
Replies
15
Views
642
Rnkhch
R
N
  • Solved
Using concatenate with variable outputs.
Replies
7
Views
481
Newbienew
N
D
  • Question Question
If formula with date & VLOOKUP
Replies
1
Views
335
etaf
etaf
E
  • Question Question
Function to return array of 10 largest absolute values while maintaining sign
Replies
3
Views
585
eurobonds
E
M
  • Question Question
Formulas with Inititals with Last Name
Replies
3
Views
136
Fluff
Fluff

Forum statistics

Threads
1,225,152
Messages
6,183,199
Members
453,151
Latest member
Lizamaison

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top