comparing one column value to another

[Craig Ballhagen]

I have 2 columns of numbers. Columns A and B. column A are loan amounts and column B are property values. I am only interested in the loan amounts that are 75% (or less) of the property values.

for example

A divided by B is less than or equal to 75%

[Trebor76]

What do you want to do with the rows that do not meet your criteria i.e., deleted, highlighted or hidden?

[ikuogs]

Enter this in column C.

C2=IF(A2>0.75*B2,"not interested","interested")

[Craig Ballhagen]

I would like to delete

[Trebor76]

Hi Craig,

Ultising Andy Pope's code from here, the following macro should do the trick (note my comments as well):

Please Login or Register  to view this content.

HTH

Robert

[DonkeyOte]

I think you could actually use the formula to your advantage such that looping the resulting values is not required... you can use SpecialCells to highlight cells containing Formulae and then subsequently differentiate further based on the resulting values of said formulae (ie Text, Numbers) ... so if you set the formula up such that it returns say a number for a valid result and a text value for those to be deleted you can use SpeicalCells to identify those to be deleted, eg:

Please Login or Register  to view this content.

Note in the above any row within the range that does not contain values for A & B is excluded from deletion... you can obviously alter the formula to suit your own needs.