Dear All,
please, give me a hint... I have a big sheet with a data. I need to find a cell in a column where in row 1 is our client no., in row 2 is month I need and in row, there is total sales. It is very easy in pivot table, but is there something similar in normal pivot as well? Some double match?
Thank you. Note, I do not use english version, please, make the formula into a file. When I open it, excel translate it into my language correctly.
Bookmarks