Re: Inserting Text into worksheet???
From: Max (demechanik_at_yahoo.com)
Date: 08/10/04
- Next message: TAJ Simmons: "Re: CONCATENATE but skip the blanks"
- Previous message: D: "Re: Im stuck in VB!"
- In reply to: Harlan Grove: "Re: Inserting Text into worksheet???"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Aug 2004 07:07:38 +0800
"Harlan Grove" <hrlngrv@aol.com> wrote
...
> Are you sure you don't have an off-by-one error? If the first match were
> found in cell A65535, then the B1 result cell would reference A65536, the
> last cell in col A of Sheet1, and cells B2 and B3 would display #REF!.
Even
> if the indexing is correct, there's no need to check past row 65534.
No, light testing returned results ok. The retrieval intentionally skips
returning
the first line per data-set, i.e. the identifier itself (e.g.: "N2AJ").
Admit I didn't test the 65Kth end. I was lazy in using the entire cols ref
(Sheet1!A:A). Didn't think the data would extend that far down <g>
> Also, if you're concerned about stray spaces in A1 when there are other
> characters too, perhaps you should also be concerned about them when they
> may be the only characters in the cell.
>
> =IF(TRIM(A1)="","",...
Yes, I missed this part out. Thanks for the refinement.
I missed mentioning a couple of assumptions, though:
a. Identifiers in col A of Sheet1 (e.g.: "N2AJ") are unique
b. Data structure is in groups of 3 lines below each identifier
-- Rgds Max xl 97 -- Please respond, in newsgroup xdemechanik <at>yahoo<dot>com ---
- Next message: TAJ Simmons: "Re: CONCATENATE but skip the blanks"
- Previous message: D: "Re: Im stuck in VB!"
- In reply to: Harlan Grove: "Re: Inserting Text into worksheet???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
