Return value in row if range of columns contains something

  • Thread starter Thread starter todd
  • Start date Start date
T

todd

I apoligize for askin ghtis question again that I
originally posterd back in may or june but can not find in
google.

I would like to have a formula that returns a "X" or what
ever when it looks to it's left and sees either a page
number or a text statement in one of several columns.

When all column sfor the row are blank in the range then
give me a blank instead of "X"

So placing in column F I would look at columns A to E and
if there is anything in those columns give me an "X" in F
for the row.

Thanks

And any advice on searching my old posts and replys would
be great
 
Thanks it works

But 1 question sometimes when empty cells it reads as
having something

I can have numbers or text number combos like as follows

4
35
wrap1
OF

etc.

Thanks again

-----Original Message-----
Try this in F1

=IF(COUNTA(A1:E1)=0,"","X")

and copy down

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"todd" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top