Hello friends
please find the attached excel 2010 file.
I want to plot only the highest high and lowest low in light yellow cells.
Regards
thilag
Hello friends
please find the attached excel 2010 file.
I want to plot only the highest high and lowest low in light yellow cells.
Regards
thilag
Hi Thilag,
Just wanted to confirm whether you would have the Column E fixed??? and based on that you wanted to plot the numbers in Col G??
Please Confirm..
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
In Column E the date of the highest high / lowest low should be plotted in the order of old date to new date.
In Column G text of High / low should be plotted with respect to Column F where high / low numer plotted.
Hi Thilag,
May I know the logic behind this picking up the last value of low and first value of High. As it can be done by using IF condition in column D and from there you can easily filter the same desired result.
Try this formula in column D2.
Formula:Please Login or Register to view this content.
It can be done with helper columns - is it ok for you
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Ok, i will use the formulas with helper rows.
see the attached file
the formula start in Column G, Column F and lastly in column E
Dear Siva
thanks for your solution, with the help of helper row i will use the sheet.
thanks again
thilag
you are welcome, thanks for your feedback and adding reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks