Hi,
I have attached the jpeg on my question. (attached the excel file)
basically, on my selected range, it has number from 0 to 6 in the five columns.
how can i set the formula (countif? or which other better formula) to detect if 4,1 and 1 exist in the range? thanks
Last edited by computeruser08; 01-26-2009 at 03:27 PM.
screen shots for error messages and the like. work book for function help
coz now i would gave to put all that in a spread sheet to calculate it and its so boring doing that!
Hello ComputerUser08,
Copy this formula into cell J2 and then drag it to fill the range.
Sincerely,
Please Login or Register to view this content.
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks