Log In
Register
Home
July 19, 2014
Offline
Hi to all of you 🙂
I would like to set-up an array formula within a cell, this formula will replace the work of a "helper column", and will
generate for me array of items, when the same items will be display within the array formula.
For more understanding, please check the attached file.
Best Regards,
Dritani
July 16, 2010
Offline
Hi Dritan,
What version of Excel are you using?
Mynda
July 19, 2014
Offline
Hi Mynda,
It is nice to hear from you, I user Excel 2010.
July 16, 2010
Offline
Hi Dritan,
That's a shame because you can use dynamic arrays available in Office 365:
=TEXTJOIN(", ",TRUE,(IFERROR(UNIQUE($B$5:B19)&" | "&COUNTIF(B5:B19,B5:B19),"")))
But I don't know of a formula that will work in Excel 2010 without a lot of head scratching, sorry.
I'd be inclined to modify your requirements to something that is possible in Excel, rather than try and force it to do something that it's not designed for.
Mynda
July 19, 2014
Offline
Thank you Mynda,
I understand what you mean, I thought that this goal can be achieved even with Excel 2010 by using and manipulated formulas like countif, or sumproduct.
Thank you once again for your time, I really appreciated 🙂
All the best,
Dritan
1 Guest(s)
