Excel formula help ,please?

[sezuh]

HI,
Good day to you,i have data in two columns and i would like to have a an excel formula to find if the two column end with the same digit numbers,is that possible?
here is an example;
Sheet5

	N	O	P	Q	R
1	DATA	FORM.RESULT	FILTERED RESULT
2	9	29	1	9	29
3	46	49		26	46
4	26	46	1	35	45
5	8	10		10	30
6	35	45	1	8	48
7	11	33		11	21
8	10	30	1	20	40
9	7	29		25	35
10	8	48	1	24	34
11	38	46		2	22
12	11	21	1	4	34
13	43	44		12	22
14	20	40	1	13	43
15	25	35	1
16	1	38
17	24	34	1
18	6	19
19	2	22	1
20	9	30
21	4	34	1
22	25	31
23	12	22	1
24	13	43	1

<colgroup>
<col style="width: 30px; font-weight: bold;">
<col style="width: 64px;">
<col style="width: 64px;">
<col style="width: 103px;">
<col style="width: 103px;">
<col style="width: 64px;"></colgroup>
<tbody>

</tbody>

Excel
tables to the web >> Excel Jeanie
HTML 4
thanks very much for any help and suggestion in advance.

 

[wigi]

Hello

For example:

=--(RIGHT(N2,1)=RIGHT(O2,1))

Copy down to other cells.

PS: Can I ask you please to use a descriptive topic title? With over 500 posts here that should be self-evident. Thanks.

 

[sezuh]

Thanks wigi,
formula works perfect,very very much appreciated.

Can I ask you please to use a descriptive topic title? With over 500 posts here that should be self-evident.

I'll do that next time,sorry.
have a nice day.