Hi Narayan,
First of all thank you for attending my request :)
I would like to add some more detail here.
I have only a table of data which is NOT SORTED (because user may add items dynamically column-wise or row-wise), and I don't have any more named ranges like you mentioned...
Hi,
I am looking for an easy way to sort a named list (which is populated from a series of column headers say from a table of data). I need to put those items in another cell as a data validation list (sorted) using a formula or anything possibly without a macro.. Please help !!!
e.g. Sheet1...