If Then Else??

K

khoo nora

Cat Indic Apple Banana Coconut Durian
Ripe (R) 10 30 50 70
Unripe (U) 60 40 20 10
Seeded (SD) 70 0 0 80
Seedless(SL) 0 70 70 0

If I have a 1 column for either Fruits (Apple, Banana, Coconut or Durian)and another on Indicators (R, U, SD, SL), at the row that I have maybe listing Apple & Unripe, I want to extract the quantity (60), how do I go about with the If Then Else function?
 
C

Claus Busch

Hi,

Am Mon, 19 Mar 2012 07:11:36 GMT schrieb khoo nora:
Cat Indic Apple Banana Coconut Durian
Ripe (R) 10 30 50 70
Unripe (U) 60 40 20 10
Seeded (SD) 70 0 0 80
Seedless(SL) 0 70 70 0
Click to expand...

try Pivot Table:
drag Indicator to column and Apple, Banana, Coconut and Durian to
Values.


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Else?? 0
Help with basic If Then Else formula 3
Nested if then else statement 8
Execl DrWatson Error 80000007 3
Sub Totals with multiple rows and columns 0
VB and VBA 0
Speed up password cracker in Excel ? 10
Importing Long String - String Manipulation (EDI EANCOM 96a) 6

Top