IF The following is data
1 01/03/14
2 02/03/14
3 03/03/14
4 04/03/14
5 05/03/14
1 06/03/14
6 07/03/14
Question is
if i want to find True or false (means following data available or not in above table.
1 06/03/14
Please share formula for this.
IF The following is data
1 01/03/14
2 02/03/14
3 03/03/14
4 04/03/14
5 05/03/14
1 06/03/14
6 07/03/14
Question is
if i want to find True or false (means following data available or not in above table.
1 06/03/14
Please share formula for this.
Let's say your table is in A2:A15 and the number you want to check is in C1
=ISNUMBER(MATCH(C1, $A$2:$A$15,0))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=IF(ISERROR(MATCH(C1,A:A,0)),FALSE,TRUE)
or
=IF(ISERROR(MATCH(41793,A:A,0)),FALSE,TRUE)
41793 is a value of 06/03/14
Appreciate the help? CLICK *
NO.... Excel is considering 1st row only....
I want to chech both 1 and 06/03/14 are available in that table. if available then true or false
e1 cell = value 1
d1 cell date
IF(COUNTIFS(A:A,E1,B:B,D1)>0,TRUE,FALSE)
thanks countifs is working...
You are welcome
Like this...
=COUNTIFS(A:A,E1,B:B,D1)>0
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks