Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which function to check any value existed withing a list?
Does anyone know which function to perform checking any value within a list?
such as a list {1,2,3,4,5,6,7,8,9} a value {4} then return true Thank you Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which function to check any value existed withing a list?
With your values in A1:A10 and your value to search for (4) in B1 try this: =COUNTIF(A1:A10,B1)0 This will return TRUE if there is a 4 (or any other value you put in B1) in the list and FALSE if that value is not in the list. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=497082 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function to determine the second small integer from a list? | Excel Discussion (Misc queries) | |||
check box function? | Excel Worksheet Functions | |||
Is there a function to give us the highest value in a list of tex | Excel Worksheet Functions | |||
Find in list function | New Users to Excel | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |