Excel List to Table
 

thanks Herbert.

Herbert Seidenberg Wrote:
Copy Date to a column with Advanced Filterunique records only.

=SUMPRODUCT((Date=Date2 R)*(Name=Name2 C)*Data)

Is it like?
Sheet1 = original (1D) list
Sheet2 = one with AdvFilter-unique
Sheet3 = resultant 2D table.
I suppose R and C are intrinsically defined as Row and Column?

still trying....
Do you think I can extend this to multi-dimension analysis?

thanx
Frankie LAU.


--
frtklau