Posted to microsoft.public.excel.misc

Terry Pinnell[_4_] Terry Pinnell[_4_] is offline

external usenet poster

Posts: 192

From data to summary?

I want to prepare a simple bar chart so must first produce a summary.

https://dl.dropboxusercontent.com/u/...ataToTable.jpg

With about a thousand data rows as shown, what would be the simplest
way to do that please?

My pencil and paper approach (after sorting the data by Suffix - Year)
was straightforward enough, but I'm curious to know if there's an
elegant alternative.

--
Terry, East Grinstead, UK

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DATA SUMMARY	M.GONZALEZ[_2_]	Excel Worksheet Functions	1	May 28th 09 05:41 PM
Copy two summary ranges to master summary sheet	a m spock	Excel Programming	5	September 13th 08 01:49 PM
Summary data	Tamara	Excel Discussion (Misc queries)	2	July 30th 08 04:39 PM
Getting Summary Data From A large Data of Files in a Directory	stratis	Excel Programming	3	July 2nd 07 02:08 PM
Use detailed data in one worksheet to create summary data as chart source	rdemyan	Charts and Charting in Excel	0	January 23rd 07 02:18 PM

All times are GMT +1. The time now is 01:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us