LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please add an INTERPOLATE function. For vector or array data. Dan Gauthier Excel Worksheet Functions 15 August 4th 09 01:48 PM
The # in my vector is absent from my array. Can I make it 0? Matherley Excel Worksheet Functions 1 July 14th 05 08:52 PM
Problem with IF condition or vector lookup? J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM
Vector lookup function GregTh Excel Worksheet Functions 1 November 5th 04 04:19 PM
Vector lookup function GregTh Excel Worksheet Functions 1 November 4th 04 08:34 PM


All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"