Hello
driller3,
It's great to see you back after 12 years! I'd be happy to help you with your formula.
To get a summary list of the bottle tables on service, you can use the following formula in cells
B24,
B25,
B26, and
B27:
Code:
=TEXTJOIN(", ",TRUE,IF($E$2:$E$22=B$23,$A$2:$A$22,""))
Here's a step-by-step breakdown of the formula:
1.
TEXTJOIN is a function that combines text strings from a range of cells, separated by a delimiter. In this case, we're using a comma and a space as the delimiter.
2.
TRUE tells the function to ignore any empty cells in the range.
3.
IF is a logical function that checks whether a condition is true or false. In this case, we're checking whether the value in column E matches the bottle type in row 23.
4.
$E$2:$E$22=B$23 is the condition we're checking.
$E$2:$E$22 is the range of cells in column E that we're checking, and
B$23 is the bottle type in row 23 that we're comparing to.
5.
$A$2:$A$22 is the range of cells in column A that we want to return if the condition is true.
6. Finally, we wrap the
IF function inside the
TEXTJOIN function to combine all the matching values into a single text string.
Make sure to enter the formula as an array formula by pressing
Ctrl+Shift+Enter instead of just
Enter. This will add curly braces around the formula and ensure that it works correctly.
I hope this helps! Let me know if you have any questions or need further assistance.