Hi there,
I'm trying to return multiple unique distinct values. The formula I have at the moment is entered in B3.
Can someone please help me rearrange it so that the unique values it returns list Horizontally as opposed to vertically as they do now?
{=IFERROR(INDEX(Data!$P$2:$P$6670...
Hi All,
Development on my last post, where Hui directed me to a great site and I found my own detailing how to return multiple values with an array formula
(http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/)
The formula I use now is...
Hi All,
Been lurking awhile using the other forums to help me tackle this data, now Just need a little more help if at all possible :)
https://docs.google.com/spreadsheet/ccc?key=0AohansBo0jMldEJGNDBXRks0djZfOWxPMlowenU5anc
Above is the link to a sample of the data I am working with...