| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match two values | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| How do I match values in one spreadsheet to values in another? | Excel Worksheet Functions | |||
| How to match values in one column to values in another? | Excel Worksheet Functions | |||
Hybrid Mode
