| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search and present lists
I have a problem in two steps.
Step 1: I have one ID column and one column with numbers. The same ID may appear several times, but all ID's must not be included (depending on other variables) What I want is to use something similar to the LOOKUP function, but that returns All values of the given ID (not just the first one) and add them together. What function should I use and how? Step 2: I want to create a third list that includes only the ID's which were included in the ID column, the sum of the numbers that they were connected with and preferrably sort them in falling order based on the numbers column. How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Flagging all records present in two (or more) separate lists | Excel Discussion (Misc queries) | |||
| Search, using lists maybe? | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Threaded Mode
