Re: Arrangement problems.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




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

.



Relevant Pages

  • RE: epoll design problems with common fork/exec patterns
    ... that two threads may add the same fd twice. ... Only closing a file will. ... It is customary to trim individuals off of CC lists when replying to a ... LKML and not trimming CC's on such posts. ...
    (Linux-Kernel)
  • Ending outline numbered lists when linked to paragraph style
    ... Does anyone know a way to control what style is set when the user hits enter ... '2) Define Font and Paragraph settings ... numbered lists in Word, when you hit enter twice, the list ...
    (microsoft.public.word.vba.general)
  • Re: merge list of tuples with list
    ... global b twice, the method 'pop' twice, call the method twice, resize the ... and stuff those two new lists into a new list... ... 10000000 loops, best of 3: 0.0325 usec per loop ...
    (comp.lang.python)
  • Re: Double messages
    ... No other lists have this ... So it must be a problem at Fedora or a more complex problem. ... We're not getting any of your messages twice. ... What does PEBKAC mean? ...
    (Fedora)
  • Re: The Green Goddess is dying
    ... I have proved, with the headers, that you replied twice to the one ... If you can't explain your allegations, please apologise. ... The fact remains that you accused me of posting the same message twice, ... I think your confusion is expanding :-)) ...
    (uk.environment.conservation)