HELP WITH A FORMULA
 

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

HELP WITH A FORMULA
 

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


Replace @mailinator.com with @tiscali.co.uk


"JNAP101" wrote in message
...
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