Highest/Lowest value using marco

Ian Mac · Apr 24th, 2002, 08:27 AM

OK, here's the problem.

I have cells on a sheet that are fed real time from a query sheet. what I'd like is if the values are in A1:A10
I'd like in B1:B10 to Keep a track of what the highest score is. i.e. if A1 is 39% then 40% then 37% I'd like B1 to keep the value 40%.

The actual book I'm working on isn't A1:A10 the cells could be A1 G67 D3 etc.

any help would be great, thanks.

Asala42 · Apr 24th, 2002, 08:35 AM

G'day,

you could actually use an intentional circular reference. For example in B1:

=Max(A1,B1)

That should keep the highest value your query gives for A1 over time.

Adam

Apr 24th, 2002, 08:27 AM	#1
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	OK, here's the problem. I have cells on a sheet that are fed real time from a query sheet. what I'd like is if the values are in A1:A10 I'd like in B1:B10 to Keep a track of what the highest score is. i.e. if A1 is 39% then 40% then 37% I'd like B1 to keep the value 40%. The actual book I'm working on isn't A1:A10 the cells could be A1 G67 D3 etc. any help would be great, thanks. __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 08:35 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	G'day, you could actually use an intentional circular reference. For example in B1: =Max(A1,B1) That should keep the highest value your query gives for A1 over time. Adam