Count only even numbers and list number in linked column

[ricklou]

Goodday

I am sure this can be done with a formula but I dont know the correct syntax to achieve the result. In G7 the formula should be B7 devided by E7 -if that value is even then list A7.Column A en B is linked together. So it must discard all values thats not even numbers and ONLY list even numbers corresponding A column number.B15 have a value of 8 and E15 a value of 2. So 8/2 =4 and in G15 the value must be 9.

Thanks in advance for any help.Sheet attached -Rep given for solution.

[Special-K]

Your description isn't that clear.
Try

=IF(MOD((B7/E7),2)=0,LEFT(A7,2)+0,"")

[lexusap]

Hi Ricklou,

This the the formula i use based on your criteria.

Please Login or Register  to view this content.

Assumptions: Round up if decimal points greater than equal to .51 and round down if decimal points less than 0.50
If the result is 0, Excel will consider the answer as even.
Not 100% what you want to show if it is even by linking A&B. If the value is true, I return value of column A, otherwise empty.

see attached workbook.

Cheers
Albert

[ricklou]

It should only count even numbers with other word if 8/4=4 it should not write 4 as the results but the corresponding column's A value in the case its 9. Hope it make better sense.Thanks special K -tested not right

[ricklou]

Hi Ricklou,

This the the formula i use based on your criteria.

Please Login or Register  to view this content.

Assumptions: Round up if decimal points greater than equal to .51 and round down if decimal points less than 0.50
If the result is 0, Excel will consider the answer as even.
Not 100% what you want to show if it is even by linking A&B. If the value is true, I return value of column A, otherwise empty.

see attached workbook.

Cheers
Albert

Hi albert thank you for your help tested yours too but its listing numbers thats not even -in this sheet only G15 and G27 should have values listed -your assumption is correct but is there any way to discard the other values? G11 have a value of 1 and 9 -how can that be seen as a even number ?#confused -tested not right too Thanks for any help -appreciated

[ricklou]

All other values must be discarded only even numbers must be listed -no decimals -sorry hope its clearer

[lexusap]

Hi,

G11 formula is =B11/E11, which is 1/9 = 0.1111. Round(0.111) = 0. Excel treat 0 as even number.

What you want to show when Value is even? e.g Display column A or Display something else?
What you want to show when Value is not even? e.g. Discard as in show blank?

Cheers
Albert

[ricklou]

Hi,

G11 formula is =B11/E11, which is 1/9 = 0.1111. Round(0.111) = 0. Excel treat 0 as even number.

What you want to show when Value is even? e.g Display column A or Display something else?
What you want to show when Value is not even? e.g. Discard as in show blank?

Cheers
Albert

Hi albert

If the number is even the the corresponding columns A number
If the number is not even dont display anything

Thanks once again for your help

[ricklou]

bump anyone ?

[lexusap]

Hi,

something like this?

Cheers