Re: Array to single row -- Any simple way to do this?

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 19:20:59 +0200

Hi
any chance you could store the data in only one column? 

--
Regards
Frank Kabel
Frankfurt, Germany
"Craig" <drmedia@aol.com> schrieb im Newsbeitrag
news:lfk5m0hr427g30dto9o02schnnvjtm363p@4ax.com...
> Is there an obvious formula to consolidate alphanumeric data across
an
> array of multiple rows and columns into one row of values which have
> appeared at least once in the array (i.e., no duplicates)?
>
> Example:
>
>      A        B          C
> 1   Apple     Pear       Orange
> 2   Grape     Apple      Pear
> 3   Melon     Orange     Grape
>
> Result: Apple, Orange, Pear, Grape, Melon
>
>
> I would also only like to show a value if it appears at least x times
> across the array.
>
> Example: (Must appear at least 2 times)
>
> Result: Apple, Orange, Pear, Grape
>
> Thanks for any and all help.
>
> CB

Relevant Pages

  • RE: delete both duplicates
    ... run a pivot table on that column, which will give you a unique list of ... i want only pear and grape to appear? ...
    (microsoft.public.excel.misc)
  • Re: Accessing the values of HoH
    ... jelly -- strawberry ...
    (perl.beginners)
  • Re: #N/A in vlookup
    ... Apple 1 ... Lookup value = A1 ... Result will return as #N/A since "Pear" cannot be found in the array. ...
    (microsoft.public.excel.misc)
  • Re: fast and simple way to match up arrays
    ... > The matching up will happen on the numbers in the 1-D array and the ... > 2, Apple ... > 3, Pear ... > My first attempt was with the Matchup function, but that is even slower. ...
    (microsoft.public.excel.programming)
  • Re: machine figure
    ... A pear, a plum, a grape, apple. ...
    (rec.puzzles)