| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a formula to search for names in columns and then add the figu
Thank you Sheloo, I will do as you advise
"Sheeloo" wrote: Glad we could help you. JLatham's solution is easier and more elegant. You do need to learn about PIVOT tables... it will save you lot of grief. Try to master VLOOKUP also. "Vercingetorix.I" wrote: Thank you, I am going over this site and it is great, I didnt expect to get an answer so quickly either... "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing figures across 2 columns. | Excel Worksheet Functions | |||
| Need Excel formula to separate names into columns, with exceptions | Excel Discussion (Misc queries) | |||
| Have 2 columns of names - need to filter out names not duplicated | Excel Worksheet Functions | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
![Vercingetorix.I[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
