Hi guys,
I am using pivot tables and need to find some values and copy them.
1. Value from N column (though sometimes its M) but what I know for sure it is the last column of the whole table. and I a am copying the highest value (the bottom right corner). How do I find and copy it ?
2. Second problem I have is in the same column (sometimes M, sometimes N) but its the very right column of the whole pivot table, I need to find 5 biggest values (apart from the biggest which is total value. For each of these values there are other information on the same row. I need to copy info from c, d, g and the m/n accordingly.
I have managed to write quite a long script already but I am still struggling with these two things. Anyone able to help ??
Thanks!
Bookmarks