Thread: Array Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default 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?