LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 09, 11:45 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Sep 2009
Posts: 1
Default copy-pasting a cell and finding lows and highs


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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to find highs and lows formula and how-to JRod Excel Worksheet Functions 5 July 6th 07 09:26 PM
Finding a match and pasting next to it Donna S Excel Discussion (Misc queries) 2 November 16th 06 07:34 PM
Counting Higher Highs rpee Excel Discussion (Misc queries) 3 October 20th 06 01:13 PM
Copy and Pasting JZ Excel Discussion (Misc queries) 1 July 25th 06 04:31 AM
Plot Highs and lows? John Charts and Charting in Excel 1 March 16th 06 09:11 AM

All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017