Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
Which function to check any value existed withing a list?
Hi Eric:
COUNTIF() will work for you. Let's say we have a set of values in column A, say A1 thru A100. In B1 we insert the value we would like to check. In B2 enter: =(COUNTIF(A1:A100,B1)0) which will return TRUE if B1 is in the list -- Gary's Student "Eric" wrote: 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 |
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 |