ExcelBanter - count function ???

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count function ??? (https://www.excelbanter.com/excel-worksheet-functions/236834-count-function.html)

count function ???

ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range

Teethless mama

count function ???

=SIGN(COUNTA(A1:J1))

" wrote:

ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range

RagDyeR

count function ???

Try this:

=--(COUNTA(A1:J1)0)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

" wrote in message
...
ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range

All times are GMT +1. The time now is 09:55 AM.