Need To Make List From Columns

  • Thread starter Thread starter BWALLACE
  • Start date Start date
B

BWALLACE

HERE IS WHAT I HAVE:

A D G H
1 Lose Firehall Pool Otter
2 Firehall Pool Smith Jones
3 Smith Pool Jones Hale
4 Otter Lose Jones Wallace


I need a forumla to look at the columns and give me a list
ie:
A
10 Lose
11 Firehall
12 Pool
13 Otter
14 Smith
15 Jones
16 Hale
17 Wallace

thanks for the help
 
Hi
I don't understand the logic behind your transformation. You result
does neither match to preocess column by column nor row by row of the
source data.
Cells A10:A13 seems to match A1:H1
but I didn't get how you come to cell A14's result
 
I think it is going across by row, but ignoring any already used.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
If the frunctions in the freely downloadable file at
http://home.pacbell.net/Beban are available to your workbook, one way is

=ArrayUniques(MakeArray(a1:a4,d1:d4,g1:g4,h1:h4,1),True) array entered
into an 8-cell column. It won't, however, preserve your initial caps.

Alan Beban
 
LET ME SEE IF I CAN EXPLANE THIS BETTER

In A1:A6,D1:D6,G1:G6,H1:H6 are job names.

in cells B1:B6, C1:C6, E1:E6, F1:F6, are cells related to that jo
name.

what i need a formula to do is to look up at A1:A6,D1:D6,G1:G6,H1:H
and make a list of the names with out duplicating any
 
Have you tried Alan's suggested solution. I just tried it and it creates a
list of words, and it is simply to get the numbers, so what is the problem?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
you have to include Alan's macros in your workbook. Otherwise the UDF
won't be recognized. So copy his code to your workbook and everything
should work
 
The quickest way is to load Alan's workbook, go into the VBE (Alt-F11 ),
select Alan's workbook, and open the code module, select it all (Ctrl-A),
copy it , and then insert a new module in your file, an d paste it. If all
that loses you, send me you Personal.xls and I will do it for you (bob .
phillips @ tiscali . co . uk - remove spaces).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bryon,

Yes I did, but I have been out for the afternoon, only just seen it. I'll
get onto it and mail it shortly.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top