bjoshi
06-30-2013, 12:38 AM
Hi,
I need help with a formula, but I don't even know if its possible.
Lets say I have the following data in my worksheet (A1,A2,A3,etc are cell references)
A1 2
A2 3
A4 4
A5 5
A6 6
In cell B1, I type in a random number, lets say 6,
Then in cell C1, i want a formula such that it gives me the 'FIRST FACTOR' of B1 from the array of values in column A.
So here the outcome of the formula would be 2 since (2*3=6),
if I had B1=9 then the outcome would be 3 since (3*3),
if I had B1=12 then the outcome would be 2 since (2*6).
I hope I have explained myself clearly enough.
Regards,
bjoshi
I need help with a formula, but I don't even know if its possible.
Lets say I have the following data in my worksheet (A1,A2,A3,etc are cell references)
A1 2
A2 3
A4 4
A5 5
A6 6
In cell B1, I type in a random number, lets say 6,
Then in cell C1, i want a formula such that it gives me the 'FIRST FACTOR' of B1 from the array of values in column A.
So here the outcome of the formula would be 2 since (2*3=6),
if I had B1=9 then the outcome would be 3 since (3*3),
if I had B1=12 then the outcome would be 2 since (2*6).
I hope I have explained myself clearly enough.
Regards,
bjoshi