Posted to microsoft.public.excel.worksheet.functions

Jennifer

external usenet poster

Posts: 385

Array Formula

Hello smart folks.

I have a spread sheet that looks like ths:

Item Number Jul-03 Aug-03 Sep-03 Oct-03
ABC 15 20 50 15
CDE 20 16 - 5
FGH 1 8 22 -
IJK 6 40 - -
LMN 16 22 30 8

I need to fil the information as follows:

7/03 ABC Qty
8/03 ABC Qty
7/03 CDE Qty
8/03 CDE Qty

etc. Can someone please help?

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
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array formula	Clash	Excel Discussion (Misc queries)	3	August 20th 06 02:39 AM
Array formula	Marcelo	Excel Worksheet Functions	3	May 24th 06 09:05 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM
Array Formula	Mitch	Excel Discussion (Misc queries)	2	April 19th 05 05:34 PM

All times are GMT +1. The time now is 02:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us