Replies to post #1855 on QID - QLD TRENDS (fka )

[TREND1]

GT
(1)Value of SEMI 10 appears in a cell "R1"
(2)I do nor know how to program Excel to pick
max and min from R1 and place it in other cells.
(3)If any one knows how to do it in Excel?
Let me know !
(4)My attempts end up in loop error.