Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MCONCAT only Visible Cells
I use MCONCAT (Laurent Longre's MOREFUNC.XLL). I often need to filter my
spreadsheet and work with only a portion of the data. I was hoping there was a way to use the MCONCAT to concatenate only the "visible cells". My spreadsheet looks like this: ColA ColB AB 123 CD 456 EF 123 If I filter ColB down to 123, I would like the MCONCAT to concatenate ColA Values AB and EF. Thank you for thinking about this. Best Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill Visible Cells with Months | New Users to Excel | |||
Select Visible Cells Only | Excel Discussion (Misc queries) | |||
Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY | Excel Worksheet Functions | |||
Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel |