Re: Arrangement problems.
- From: Bryan Hessey <Bryan.Hessey.26sqbm_1145928301.1802@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Apr 2006 20:24:24 -0500
do you mean twice as many rows or twice as many columns? if twice as
many rows then you have triplicates?
To see 4 headers above 3 columns can be a little confusing
note, it is also confusing if you use what are standard column headers
A B C & D as column A entries (without a heading entry), however, the
formula will still produce what you need, just delete the blank column
D when you are done.
--
Blah Wrote:
Assuming A = ident, B C & D = set, max 4 duplicates:
Actually A, B, C, and D are the names which have a total of four
replicates Z, Y, X, and M split across two seperate out of order
lists. The key problem is that the second list has twice as many
entries as the first so I can't just arrange by name and them paste
the
lists next to each other. I need to merge the two lists together so
that all four replicates end up next to their name on a single row and
under their respective replicate name.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=535746
.
- Follow-Ups:
- Re: Arrangement problems.
- From: Blah
- Re: Arrangement problems.
- References:
- Arrangement problems.
- From: Blah
- Re: Arrangement problems.
- From: Blah
- Arrangement problems.
- Prev by Date: Re: Summing quantities based on like criteria?
- Next by Date: Re: Need to have cell C8 contain contents of Cell G(formula)
- Previous by thread: Re: Arrangement problems.
- Next by thread: Re: Arrangement problems.
- Index(es):
Relevant Pages
|