Excel List to Table

F

frtklau

thanks Herbert.

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

=SUMPRODUCT((Date=Date2 R)*(Name=Name2 C)*Data)
Click to expand...

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.
 
Top