Reply to thread

Message: [QUOTE="Vasanth, post: 7401389"] Hi Below is my requirement I have 100 rows in a excel . I need to sort this rows based on column .But this sorting is not ascending or in descending order .I need th sorting to be done by the order I mention Eg: Rows present in Excel AAA 123 FFF 111 GGG 456 DDD 654 AAA 775 FFF 986 TTT 777 I need the Column A to be sorted in this order DDD TTT AAA FFF GGG Hence my output must be like this DDD 654 TTT 777 AAA 123 AAA 775 FFF 986 FFF 986 GGG 456 Please let me know whether this can be achieved with excel macro o formulas [/QUOTE]