Keyword Questions, Protocol Guidelines, and SHIPping
dicentra63
dicentra at xmission.com
Tue Oct 8 00:04:49 UTC 2002
--- In HP4GU-FAQ at y..., eloiseherisson at a... wrote:
> .....................
> Another question on how Excel sorting works.
>
> I have quite a lot of entries that take up more than one row and one
keyword
> (such as SHIP) which applies to keywords in all/both rows. In a
sort, will
> 'SHIP' only appear with those names on the same row of the chart,
despite
> their all having the same message number?
Excel doesn't know what having the same message number means, so yes,
you'd have to include the word SHIP on each row that contains shipping.
In your example, if your topics rows/columns look like this:
SHIP, LOLLIPOPS, FLIRTIAC
Snape, Lily, Filch
Mrs. Norris, Malfoy
The first row would be found amongst the other SHIPs, the second row
would be sorted with the other Snapes, and Mrs. Norris would be with
other Mrs. Norrises.
This is assuming that the first column is the first row you're sorting
by. I'll have to come up with a sorting rules section for the Help
doc, but not quite yet.
--Dicey, going home to set up her new computer
More information about the HP4GU-FAQ
archive