How to match the values?
 

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] [b] [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

How to match the values?
 

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

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


"Eric" wrote:

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] [b] [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

How to match the values?
 

Try this:

=--(SUMPRODUCT(--(A$2:A$6<=A2),--(B$2:B$6=B2))1)

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
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] [b] [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

How to match the values?
 

Oops; I dont think I have understood your query correctly


"Jacob Skaria" wrote:

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

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


"Eric" wrote:

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] [b] [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

How to match the values?
 

Assuming [A], [b] 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.

Eric wrote:
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] [b] [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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1

How to match the values?
 

Assuming [A], [b] 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.

Eric wrote:
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] [b] [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

--
Message posted via http://www.officekb.com