How to match the values?

E

Eric

Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric
 
J

Jacob Skaria

Oops; I dont think I have understood your query correctly


Jacob Skaria said:
In C1
=IF(COUNTIF(A:A,B1),1,"")

If this post helps click Yes
---------------
Jacob Skaria


Eric said:
Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric
 
P

pogiman via OfficeKB.com

Assuming [A], and [C] is in the first row enter this formula in C2:

=IF(countif($A3:$A$<last row/record#>,$B2)>0,1,0) ->then copy the formula
downward.

The formula does not include the current row in column A to match column B.
If you would like to include the current row, change $A3 to $A2.
Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric
 
P

pogiman via OfficeKB.com

Assuming [A], and [C] is in the first row enter this formula in C2:

=IF(countif($A3:$A$<last row/record#>,$B2)>0,1,0) ->then copy the formula
downward.

The formula does not include the current row in column A to match column B.
If you would like to include the current row, change $A3 to $A2.
Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top