- Hot Topics
Excel Highest & Lowest
Z1=1 or 2 as soon as system time equals 'start time' & 'end time' respectively else Z1=0 (default) During this "Time Period" when Z1 first becomes equal to 1 & finally when it becomes equal to 2; C2:C200 & D2 D200 keeps on updating its values continuously. Output required: in E2:E200 & F2:F200 which should be the highest value of respective cell address of C column & the lowest value of respective cell address of D column AS LONG AS Z1=1. Ex: For Z1=1 C2=200.22 D2=507.43 E2=200.22 F2=507.43 C2=201.34 D2=50
This question generated 11 answers. To proceed to the answers, click here.
This thread is current as of September 14, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel