Macro to match decimals, write only decimal match

Good day

Wonder if someone can help me.Rep given for a solution -this is fairly straight forward for someone with excel vb skills.

Got a spreadsheet Column A from number 1-80
E1 I have the decimal I would like to match. As per my example 4.8. E2 is the devider as per example 5

Looking for a macro that can go from 1 -80 and devide it through E2 to get the decimal value. If the decimal value last digit match the value in E1 the results must be written in H1 -if the number dnt match then the number must not be written.

Example below

G1 Value match decimal
Decimal value 4.8 >>> 24 >>>>>>>>>>>>>>>24/5=4.8
Matches 3.8 >>> 19
5.8 >>> 29
6.8 >>> 34
7.8 >>> 39
8.8 >>> 44

E1 is a variable decimal and can change
E2 devider is a variable and can change

Only need G1 ascending the numbers that match the decimal

Sample spreedsheet attached and any help appreciated + rep given to someone that can solve it.

Many thanks

Ricklou

ricklou,

Does it have to be a macro?
You could use this formula in cell G2 and copy down to G81:

Please Login or Register  to view this content.

The formula will only pull the desired matches. Once they have all been found the remaining cells will be blanks.

how many places (and btw who gives ***** about rep)

Tigeravatar thanks works just as good as a macro...........thank you so much -rep given thanks

But what if the cells to use change ? Tried it with another value but it dont work

So you want it to match to a single digit when rounded? e.g. .16 would round and equal to .2?

ricklou,

Attached is a modified version of the Decimals workbook you provided.
I added a new item in column D, "Decimal places to round to" which has its value in cell E3 defined by this formula:

Please Login or Register  to view this content.

Basically it determines how many numbers are after the decimal point in cell E1. So with the 6.2 example, there is only 1 number after the decimal.
This number is used to round to that many decimal places when dividing by the "cells to use" (denominator).

This is the updated formula in cell G2 and copied down:

Please Login or Register  to view this content.

You can see that 37 is one of the returned values, which is expected.