yes, it works! thankyou!
"Frank Kabel" wrote:
Hi
not really sure why you compare the length of the string? But one thing to
check first: Have you entered this formula as array formula with
CTRL+sHIFT+ENTER
"kalz" wrote:
Hi,
e.g. I'm to count the no. of products < expected = 3!, this is the
extracted data column (Sheet 1):
product
1
2
1
3
1
in Sheet 2 :
this's the formula to achieve the result-
=SUM(IF(LEN(Sheet1!A2:A100)0,1/COUNTIF(Sheet1!A2:A100,Sheet1!A2:A100)))
the displayed result in the cell is - 0.333...
but, the result in the formula argument window shows formula result =3.
do u know how this happen?
thx lox,
"Frank Kabel" wrote:
Hi
- post your exact formula
- post the current result
- post the result expected
- post the values in the referenced cells
"kalz" wrote:
Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?
|