masud8956
Board Regular
- Joined
- Oct 22, 2016
- Messages
- 163
- Office Version
- 2016
- 2011
- 2007
- Platform
- Windows
Hi,
I am using the following formula in my worksheet:
=IFERROR(INDEX($H$74:$H$783,MATCH(0,COUNTIF($H$74:$H$783,"<"&$H$74:$H$783)-SUM(COUNTIF($H$74:$H$783,F$797:F797)),0)),"")
I am getting the intended list that i want with duplicates removed. But the List is appearing in alphabetical order.
What modification do I need to keep the order unchanged? I want it in the order of input.
I prefer NOT to use VBA.
I am using the following formula in my worksheet:
=IFERROR(INDEX($H$74:$H$783,MATCH(0,COUNTIF($H$74:$H$783,"<"&$H$74:$H$783)-SUM(COUNTIF($H$74:$H$783,F$797:F797)),0)),"")
I am getting the intended list that i want with duplicates removed. But the List is appearing in alphabetical order.
What modification do I need to keep the order unchanged? I want it in the order of input.
I prefer NOT to use VBA.