frankee_gee
Board Regular
- Joined
- Mar 3, 2008
- Messages
- 144
- Office Version
- 365
- 2016
- Platform
- Windows
Hello Mr. Excel,
Please help. I receive a report with about 50 rows of data daily. Two of the headings have to be identical. I was hoping I could use a formula to do this for me.
<tbody>
</tbody>
It does not have to be a "Y" or "N" ...just something that indicates that there is a mismatch. like a "1" or "0"...
Thanks for your time.
Frank.
Please help. I receive a report with about 50 rows of data daily. Two of the headings have to be identical. I was hoping I could use a formula to do this for me.
A | B | C (Want results here) |
Activity Date | Transaction Date | Match yes / no |
1/1/2014 | 1/1/2014 | y |
1/2/2014 | 1/3/2014 | n |
1/6/2014 | 1/6/2014 | y |
<tbody>
</tbody>
It does not have to be a "Y" or "N" ...just something that indicates that there is a mismatch. like a "1" or "0"...
Thanks for your time.
Frank.