software

I have an imported text file (roughly 30,000lines). What I need is to see if
a column has the value quot;SAURquot; and if so, count the columns with quot;Squot; in the
next 7 rows below it and 2 columns to the right.

Hi,

Try,

=IF(RC[-3]=quot;SAURquot;,COUNTIF(R[1]C[-1]:R[7]C[-1],quot;Squot;),0)

I set this up with R1C1 ref style on amp; put my formula in column 4. My dummy
data was in col 1 (SAUR, lt;gt;SAUR) amp; column 3 (S amp; lt;gt;S). You will need to tweak
if you can't put the formula there.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Lost in Microbiologyquot; wrote:

gt; I have an imported text file (roughly 30,000lines). What I need is to see if
gt; a column has the value quot;SAURquot; and if so, count the columns with quot;Squot; in the
gt; next 7 rows below it and 2 columns to the right.

Chris,

When I paste this into the worksheet, nothing happens. Am I doing something
wrong? Do I run a macro and insert there?

Thanks

quot;Chris Marlowquot; wrote:

gt; Hi,
gt;
gt; Try,
gt;
gt; =IF(RC[-3]=quot;SAURquot;,COUNTIF(R[1]C[-1]:R[7]C[-1],quot;Squot;),0)
gt;
gt; I set this up with R1C1 ref style on amp; put my formula in column 4. My dummy
gt; data was in col 1 (SAUR, lt;gt;SAUR) amp; column 3 (S amp; lt;gt;S). You will need to tweak
gt; if you can't put the formula there.
gt;
gt; Regards,
gt;
gt; Chris.
gt;
gt; --
gt; Chris Marlow
gt; MCSD.NET, Microsoft Office XP Master
gt;
gt;
gt; quot;Lost in Microbiologyquot; wrote:
gt;
gt; gt; I have an imported text file (roughly 30,000lines). What I need is to see if
gt; gt; a column has the value quot;SAURquot; and if so, count the columns with quot;Squot; in the
gt; gt; next 7 rows below it and 2 columns to the right.