| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
another array question
Thanks to those who responded to my previous post. On the same spreadsheet
(Excel 2000) I have these values in columns A & B ID1220 - gray ID1220 - white ID1624 - gray ID1220 - white ID1624 - white ID1220 - red Here I am trying to find out how many units I have of the various colors of a particular size. What I want to know is: ID1220 - gray = 1 ID1220 - white = 2 ID1220 - red = 1 Again, I am assuming this has to be done in an array but I know very little about them. Thanks in advance. Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP ARRAY | Excel Discussion (Misc queries) | |||
| Can I use an array function to solve my question??? | Excel Worksheet Functions | |||
| Display an array of references | Excel Worksheet Functions | |||
| Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
| Multicell Array Formula and List Question | Excel Worksheet Functions | |||
Threaded Mode
