the formula iam looking for is:if in E1:N11 the number 14 exist extrct him to cell B2 and in B1 count how may times exist in range E1:N11.
thank you so much guys!
the formula iam looking for is:if in E1:N11 the number 14 exist extrct him to cell B2 and in B1 count how may times exist in range E1:N11.
thank you so much guys!
in B2
=IF(COUNTIF(E1:N11,14)>0,14,"")
in B1
=COUNTIF(E1:N11,14)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
here i attached a workgook. thanks
super!!! is working,thank you
special -k, and how can i say if the number 14 and number 22 ,extract them in column A:A?
A number cant be "14 AND 22", it has to be 14 OR 22, it cant be both.
in C2
=IF(COUNTIF(E1:N11,22)>0,22,"")
in C1
=COUNTIF(E1:N11,22)
Or better still...
in B1 put 14
in B2 put 22
in C1
=COUNTIF(E1:N11,B1)
in C2
=IF(COUNTIF(E1:N11,C2)>0,C2,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks