Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup that returns vector(array)
I have on eproblem. I have a table that contains two columns. One is type of
product(I have 6 different products)and another is quality characteristic for those products. I need some function that can look at the first column and returns vector with the values just for one type of product. If that is possible I would then use that vector to put in countif function in order to get percentages of different product ranges for that characteristic. -- You`re going to rip just what you`ve saw |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup that returns vector(array)
Something like
=SUMIF(A2:A20,5490,D2:D20)/SUM(D2:D20) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "BOB77" wrote in message ... I have on eproblem. I have a table that contains two columns. One is type of product(I have 6 different products)and another is quality characteristic for those products. I need some function that can look at the first column and returns vector with the values just for one type of product. If that is possible I would then use that vector to put in countif function in order to get percentages of different product ranges for that characteristic. -- You`re going to rip just what you`ve saw |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup that returns vector(array)
I tried sumif and I get one value. I only did first part of the
equation(SUMIF(A2:A20,5490,D2:D20). Excel summed the corresponding values of desired items from first column which is good step, because desired values were recognized. But I don€št want to sum them I want to get vector vector with all values that match the criteria. If you have any other idea please reply. You`re going to rip just what you`ve saw "Bob Phillips" wrote: Something like =SUMIF(A2:A20,5490,D2:D20)/SUM(D2:D20) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "BOB77" wrote in message ... I have on eproblem. I have a table that contains two columns. One is type of product(I have 6 different products)and another is quality characteristic for those products. I need some function that can look at the first column and returns vector with the values just for one type of product. If that is possible I would then use that vector to put in countif function in order to get percentages of different product ranges for that characteristic. -- You`re going to rip just what you`ve saw |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup that returns vector(array)
You said you were going to use it in a formula to get the percentage so I
gave it all to you in one formula. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "BOB77" wrote in message ... I tried sumif and I get one value. I only did first part of the equation(SUMIF(A2:A20,5490,D2:D20). Excel summed the corresponding values of desired items from first column which is good step, because desired values were recognized. But I don,t want to sum them I want to get vector vector with all values that match the criteria. If you have any other idea please reply. You`re going to rip just what you`ve saw "Bob Phillips" wrote: Something like =SUMIF(A2:A20,5490,D2:D20)/SUM(D2:D20) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "BOB77" wrote in message ... I have on eproblem. I have a table that contains two columns. One is type of product(I have 6 different products)and another is quality characteristic for those products. I need some function that can look at the first column and returns vector with the values just for one type of product. If that is possible I would then use that vector to put in countif function in order to get percentages of different product ranges for that characteristic. -- You`re going to rip just what you`ve saw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please add an INTERPOLATE function. For vector or array data. | Excel Worksheet Functions | |||
The # in my vector is absent from my array. Can I make it 0? | Excel Worksheet Functions | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
Vector lookup function | Excel Worksheet Functions | |||
Vector lookup function | Excel Worksheet Functions |