Borut
12-12-2020, 07:51 AM
Hello,
How can I count left alignment cell value?
In range e10:ai10, I have empty cells, filled cells, witch are
alignment left, right and center.
I would like to count only left alignment values,
with criteria in 1 row up (e9:ai9).
If e10 is left alignment and cell e9 is not "B" or "L" or "K" (8 criterita for not to count), then ... and so on to ai10. Rezult is how many cell is ok for this criteria.
It is possible to solve with udf?
How can I count left alignment cell value?
In range e10:ai10, I have empty cells, filled cells, witch are
alignment left, right and center.
I would like to count only left alignment values,
with criteria in 1 row up (e9:ai9).
If e10 is left alignment and cell e9 is not "B" or "L" or "K" (8 criterita for not to count), then ... and so on to ai10. Rezult is how many cell is ok for this criteria.
It is possible to solve with udf?