Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table that has three values seen below. I would like to
transfer/copy these values into a new worksheet that has the date listed horizontally on the top and the fund # listed vertically. If it doesn't return a data it should be 0. No pivot table suggestions please. Please see below. Thank you in advance How Data comes in Fund# Date Amount 2 07/21/08 45 9 07/21/08 36 21 07/18/08 22 61 07/21/08 49 45 07/21/08 45 Result 07/19/08 07/20/08 07/21/08 07/22/08 2 0 0 45 0 9 0 0 49 0 21 0 0 0 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Q: criteria based vlookup | Excel Discussion (Misc queries) | |||
VLookup based on two criteria | Excel Discussion (Misc queries) | |||
VLookup based on two criteria | Excel Discussion (Misc queries) | |||
Add a row based on other criteria | Excel Worksheet Functions | |||
Need help looking up value based on criteria | Excel Worksheet Functions |