copy-pasting a cell and finding lows and highs

F

Fisherman

Hello,

How can I make an excel function that copy-pastes a cell to other location
if certain criteria fulfills? (eg. copy-pastes cell B4 to C5 if A1:A20
contains word "OK")

I also need to find out how much lower at lowest the following values are
after reaching the wanted level before getting a higher or lower value.
(let's say I have a temparature of 60 F that rises to 80 F, and I need to
know how low it goes at lowest after reaching 80 before it climbs to 100 F
the next day, and how high it gets at maximum before cooling back to 60. Or
return negative value (-20 in this case) if it doesn't get to 100 before
going back to 60. I have separate columns for high and low values)

Sorry for the fuzzy and tricky question. I have been thinking this for a
while but haven't found an answer yet. My warmest thanks if you can solve the
problem!
 
D

Dan DeHaven

Fisherman,

Here is a formula that will look for "OK" in column "A" and if it find
it then it returns the value next to it in column "B". If it doesn'
find "OK" it returns nothing.

=IF(ISNA(VLOOKUP("OK",$A$1:$B$50,2,FALSE)),"",VLOOKUP("OK",$A$1:$B$50,2,FALSE))

This assumes your data is in the range "A1:B50", but you'll need t
adjust the "B50" to match your actual last row of data.

Also this only finds the first occurrence of "OK" if you have multipl
"OK" let me know and I can make one that works with that.

Regarding the second question about the complex formula, it would b
much easier if you can attach a spreadsheet that contains your data an
outline briefly your specification for the formula. Also what version o
Excel you're using (2003, 2007?).

At any rate it totally possible, but it will be much quicker if I ca
see the file.

Cheers,

Dan
 
F

Fisherman

Thanks for your fast response,

I didn't know how to attach worksheets here so I mailed the actual problem
with Excel documents to your email.

Best Regards

"Fisherman"



"Dan DeHaven" kirjoitti:
 

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

Top