HELP WITH A FORMULA

[JNAP101]

WHAT FORMULA WOULD I WRITE TO MAKE THE DETAIL IN SCHEDULE "A" POPULATE
SCHEDULE "B" BY DATE, BY CATAGORY? ANY ASSITANCE WOULD BE GREATLY APPECIATED.

SCHEDULE "A"
PRODUCE DATE SOLD {LBS}
GRAPES 4/11/2008 25
APPLES 4/9/2008 26
ORANGES 4/11/2008 85
PEARS 4/10/2008 96

SCHEDULE "B"
DATE GRAPES APPLES ORANGES PEARS BANANAS
4/9/2008 26
4/10/2008 96
4/11/2008 25 85 120

Thank you



BANANAS 4/11/2008 120

 

[Sandy Mann]

Two possible answers.

1. Create a Pivot Table.

2. With your Shedule A data in A1:C7 I inserted a new Column B with the
formula in B3 (The row with "GRAPES" in it)

=A3&C3

Next with the Labels "Date" & the Fruit names in A2:F2 of another sheet and
the unique dates down A3:A5 enter the formula in B3:

=IF(ISNA(VLOOKUP(B$2&$A3,Sheet2!$B$3:$D$7,3,FALSE)),"",VLOOKUP(B$2&$A3,Sheet2!$B$3:$D$7,3,FALSE))

and copy across and then down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk