Advanced filter and transpose needs fix..
Advanced filter and transpose needs fix..
Hello All,
Two things:
The advanced filter is not correctly filtering the data as unique. There is a column containing repeating numbers of rows have 12 monthly dates that repeat. When the advanced filter is invoked to filter column A as unique data, it pulling in 2/1/2012 twice
Secondly, when the “Transpose” key is pressed multiple times, it keeps filling adjacent rows and columns very strangely. The expectation is every time the transpose is pressed, it only fills in the range “mySourceRange”, no other cells
So the ideal goal is to filter unique values from column A to column B – which will then have only 12 months - no repeating data here. Please note: Column A can have upto 35 000 rows in actual,
Then sort that unique list and put in horizontally into range “mySourceRange”
Thank you
transposemm.xlsm
Hello All,
Two things:
The advanced filter is not correctly filtering the data as unique. There is a column containing repeating numbers of rows have 12 monthly dates that repeat. When the advanced filter is invoked to filter column A as unique data, it pulling in 2/1/2012 twice
Secondly, when the “Transpose” key is pressed multiple times, it keeps filling adjacent rows and columns very strangely. The expectation is every time the transpose is pressed, it only fills in the range “mySourceRange”, no other cells
So the ideal goal is to filter unique values from column A to column B – which will then have only 12 months - no repeating data here. Please note: Column A can have upto 35 000 rows in actual,
Then sort that unique list and put in horizontally into range “mySourceRange”
Thank you
transposemm.xlsm
ASKER
Or if it could be done more efficiently - whichever way really..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect !! aikimark
That works sweet
Thank you :)
That works sweet
Thank you :)
ASKER
Hello Aikimark,
Here is a follow up question if you are interested
https://www.experts-exchange.com/questions/27828838/Tranpose-With-Spaces.html
Here is a follow up question if you are interested
https://www.experts-exchange.com/questions/27828838/Tranpose-With-Spaces.html
ASKER
StrangeTranposeBehaviour.png
Duplicates.png