Table

S

sbs

I have a list of accounts payable with the name (in column A) and the
due date (in column B) and the amount (in column C). I want to
re-create this, sorted by name (in column A) and the due dates at the
top of each column, with the amount placed in the cell which
intersects with the name and the date.

I have an example as a simple attachment if you can tell me how to
display it. Does this sound like I should use a Pivot Table, or a
Macro, or can you please provide me some help.

Regards..
 
D

duane

original table (of 3 names only) in a4:c6

if you know the dates or can easily create the row of dates

names listed starting in a11:a13, and dates in b10:d10

=SUMPRODUCT(($A$4:$A$6=$A11)*($B$4:$B$6=B$10)*($C$4:$C$6))

in cell b11 and copied thru cell d13

or yes, a pivot table would do i
 
Top