Thanks davesexcel and daddylonglegs for the reply. I really would like
to have it so that anyone can use my spreadsheet without having to load
add-ons so I think the best bet would be to try using some formula. I
tried using the formula daddylonglegs posted: =MAX(IF(MOD(A1,ROW(INDIRECT("1:"&A1)))=0,IF(MOD(B1
,ROW(INDIRECT("1:"&A1)))=0,ROW(INDIRECT("1:"&A1))) )) I'm using fields C2 and D2 though so I replaced all the A1 attributes
with an attribute of C2 and the B1 attribute with the attribute D2. In
cell C2 I had the value: 4; and in D2 I had the value: 12. Therefore, I
should have gotten an answer of: 4; however, I got an answer of 1. An
help is greatly appreciated. Thanks.


--
blcarmadillo
------------------------------------------------------------------------
blcarmadillo's Profile: http://www.excelforum.com/member.php...o&userid=32841
View this thread: http://www.excelforum.com/showthread...hreadid=526344