Returning Multiple Results into a Single Cell

**hmltnangel** · 10-10-2018, 06:41 AM

Afternoon folks, I do hope you can help.

I have a worksheet called "Daily MI". In cell A5, I need it to return some details from another sheet called "Car Data". The details are in the "Car Data" sheet as follows. Column F has a status - five possible statuses .... New, Old, Trade, Broken, Sold. I need cell A5 in the "Daily MI" sheet to display the counts of the statuses all in one cell.

eg
Sold - 1
New - 5
etc etc

Can this be done VBA or otherwise?

**Kaper** · 10-10-2018, 06:55 AM

Start with formula in A5:

Formula:

Please Login or Register  to view this content.

Remember to format this cell with wrapping text enabled and make it high enough to accomodate output. If wotks - add next texts and counts with CHAR(10) (new line) between them.

**hmltnangel** · 10-12-2018, 08:46 AM

Absolutely spot on. Thank you. I was able to use this as well and adapt to fit a few other requirements :D

**Kaper** · 10-12-2018, 09:18 AM

Glad to hear that!
Thanks for Rep+ and for marking thread solved

Returning Multiple Results into a Single Cell

LinkBack

Thread Tools

Rate This Thread

Display

Returning Multiple Results into a Single Cell

Re: Returning Multiple Results into a Single Cell

Re: Returning Multiple Results into a Single Cell

Re: Returning Multiple Results into a Single Cell

Thread Information

Users Browsing this Thread

Similar Threads

Vlookup returning multiple values in one single cell

[SOLVED] Returning Multiple description Through A Vlookup in a single cell through vba

[SOLVED] Returning multiple matches and and displaying in a single cell with using UDF

Hi, Need help with returning multiple values into single cell

Returning a value to a single cell based on multiple values elsewhere.

Returning a multiple-result lookup to a single cell

Returning single cell value looking at range across multiple sheets

Bookmarks

Bookmarks

Posting Permissions