![]() |
|
#1
|
|||
|
|||
![]() Quote:
From A1 to A6: 4,0,5,1,2,1 Then Code:
COUNTIF($A$1:$A$6,1) ' will return 2 |
#2
|
||||
|
||||
![]()
Yes, and what is wrong about it? Aren't you looking for the smallest value different from 0 or 1 ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Nope. I've confused myself. You're right.
|
![]() |
|