Posted to microsoft.public.excel.misc

external usenet poster

Posts: 61

dget and dsum

shift 1 shift 2 shift 3
1/1/2008 32 45 28
1/2/2008 49 36 73
1/3/2008 21 16 81

Have data as above and would like to make it as below:
1/1/2008 32
1/1/2008 45
1/1/2008 28
1/2/2008 49
1/2/2008 36
1/2/2008 73

Have 270 plus lines of data and have been trying to use dget but
can't seem to get it to work

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
DGET/DSUM etc	ron_b	Excel Worksheet Functions	2	March 16th 08 01:44 PM
dget or dsum criteria	maffei	Excel Worksheet Functions	1	April 27th 07 05:45 PM
dget or dsum? that is the question	justaguyfromky	Excel Discussion (Misc queries)	1	November 10th 05 03:10 AM
dget or dsum? that is the question	bpeltzer	Excel Discussion (Misc queries)	0	November 10th 05 12:30 AM
using dget	Leslie	Excel Worksheet Functions	0	June 24th 05 03:53 PM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us