Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have two tables that each have 2 columns. The first column in the first table is composed of dates that are in ascending order, but have some duplicate dates and missing dates. The second column has numbered values. The first column in the second a table is all dates 1/1/08 to present. I want the second column to be an output of a function. The first part of the function is easy and would find a date in the first table and return the corresponding column 2 value. The tricky part is that when there are two dates, or more than one, then I want the output be the sum of the column 2 values. Does this make sense? Thanks for your help. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
How to sort text and letter hybrid (eg A1, A2, A10) in order? | Excel Worksheet Functions | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |