Hi,
If someone know a tread to please let me know.
Please I need vba code or udf to copy from columns T5,U5,V5,W5 (10,000 rows each column) to Correspondent Columns starting with Column Y5, then on Z5, AA5, AB5
with following condition:
-.Paste at Top (Starting in Y5,Z5,AA5,AB5)
-.Only cell with data (skip blank cell)
-.Digit on Sort Order
-.Unique Distinct digits
Example of Unique Distinct digits:
Cell T13 -> 2,2,2,1,1
Cell T15 -> 1,2,2,2,1
Cell T20 -> 2,1,2,1,2
This 3 cell Values Are equivalent to sorted Value on Cell Y10 -> 1,1,2,2,2
Another example:
Cell U6 -> 4,3,1,1,3
Cell U15 -> 3,3,4,1,1
Cell U22 -> 1,4,3,1,3
Cell U23 -> 4,1,3,3,1
The 4 cell Values Are equivalent to sorted Value on Cell Z5 -> 1,1,3,3,4
Thank you !!!!!!!!!!
Bookmarks