I want to capture the high value of a cell

P

polarbearchp

Myrna,
Thanks for the response. A macro would work if it could look at th
cell and seed if the result of the formula was a 1 and if so change th
cell to a value of 1. Then the rest of what I have should work. I
that possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Excel Countif Function - Calculating Between Two Sets of Values 3
Drop down list control value in vba 2
Is there a function to count how many times a cells value is used? 0
Excel does not accept text format! 0
trouble with (complicated) vlookup searching another workbook 2
VLOOKUP & Data Validation 0
Losing Data From Formulas When Cell Variable Changes 6

Top