b3ta.com board
You are not logged in. Login or Signup
Home » Messageboard » XXX » Message 9394489 (Thread)

#
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....)
(I helped save b3ta! epiphany coming live from sweden, Sat 25 Apr 2009, 15:58, archived)
# 1. Open excel
2. Click in any box
3. Type "MACROS"
4. Click 'ignore' on facetious forum post.
(I helped save b3ta! Fishcat Difficult difficult lemon difficult., Sat 25 Apr 2009, 16:13, archived)
# ^ This, then Ctrl+F4
(I helped save b3ta! Wobbly Bloke Hello, did I miss anything on, Sat 25 Apr 2009, 16:28, archived)
# Not sure you need macros or graphs...
=max(column range) should get it.
(Richy_T hundreds if not thousands of dollars, Sat 25 Apr 2009, 16:24, archived)
# indeed! if the data is in a spreadsheet, then you have all that you need
the graphs are just a visualisation of that data :)
(I helped save b3ta! The Alchemist king of the needlessly complicated, Sat 25 Apr 2009, 16:52, archived)
# I guess it depends if there are multiple peaks.
If you're after a certain region, then it may or may not be the most intense peak.
(I helped save b3ta! Colonel Boris "...a desperate Buzzfeed imitation...", Sat 25 Apr 2009, 17:02, archived)
# That's true.
For automated graph plotting, something like gnuplot might prove more weildy.

(Richy_T hundreds if not thousands of dollars, Sat 25 Apr 2009, 17:59, archived)