
TJ: does anyone know how to write macros in excel?
Ive got a spreadsheet of like 105 graphs I want to plot and find out what the peak of these graphs is, and know how I can do this without having to do in manually (ie plotting each graph then looking where the max is etc....)
( ,
Sat 25 Apr 2009, 15:58,
archived)
Ive got a spreadsheet of like 105 graphs I want to plot and find out what the peak of these graphs is, and know how I can do this without having to do in manually (ie plotting each graph then looking where the max is etc....)

2. Click in any box
3. Type "MACROS"
4. Click 'ignore' on facetious forum post.
( ,
Sat 25 Apr 2009, 16:13,
archived)
3. Type "MACROS"
4. Click 'ignore' on facetious forum post.

=max(column range) should get it.
( ,
Sat 25 Apr 2009, 16:24,
archived)

the graphs are just a visualisation of that data :)
( ,
Sat 25 Apr 2009, 16:52,
archived)