I have an imported text file (roughly 30,000lines). What I need is to see if

a column has the value "SAUR" and if so, count the columns with "S" in the

next 7 rows below it and 2 columns to the right.

Hi,

Try,

=IF(RC[-3]="SAUR",COUNTIF(R[1]C[-1]:R[7]C[-1],"S"),0)

I set this up with R1C1 ref style on & put my formula in column 4. My dummy

data was in col 1 (SAUR, <>SAUR) & column 3 (S & <>S). You will need to tweak

if you can't put the formula there.

Regards,

Chris.

--

Chris Marlow

MCSD.NET, Microsoft Office XP Master

Try,

=IF(RC[-3]="SAUR",COUNTIF(R[1]C[-1]:R[7]C[-1],"S"),0)

I set this up with R1C1 ref style on & put my formula in column 4. My dummy

data was in col 1 (SAUR, <>SAUR) & column 3 (S & <>S). You will need to tweak

if you can't put the formula there.

Regards,

Chris.

--

Chris Marlow

MCSD.NET, Microsoft Office XP Master

Chris,

When I paste this into the worksheet, nothing happens. Am I doing something

wrong? Do I run a macro and insert there?

Thanks

When I paste this into the worksheet, nothing happens. Am I doing something

wrong? Do I run a macro and insert there?

Thanks

1. Inputting cell value from source cell based on value in adjacent cell.

2. Replacing a cell value with the value from an adjacent cell.

3. FIND CELL VALUE THEN INCREASE THE VALUE OF THE ADJACENT CELL

4. count cells, then reset count when value in another cell chang

5. count cells, then reset count when value in another cell changes

6. Sum only specific cells based on value in adjacent cell

7. Format cell based on adjacent cells values

8. automatically fill in a cell if the adjacent cell has any value

9. If Cell Color is yellow set adjacent cell to value

10. change current cell colour based on the value of adjacent cell on other worksheet

11. I want to format a cell based on an adjacent cells value

12. Formula refrencing cell with a value of adjacent cell

13. VBA code to hightlight range of cells based on the value of another adjacent cell

14. change current cell colour based on the value of adjacent cell on

15. referencing values in adjacent cells to selected cell

3 post • Page:**1** of **1**