Dear Excel Experts,
I just recently facing an issue on sorting data with index match formula. The sorting from filter doesn't seem to work accordingly when I tried to sort the data based on alphabetical order and the output remain the same. Below follow the my formula. Is there any way to sort the column with formula intact
Formula:
Please Login or Register to view this content.
The value in C5 is derived from this formula
Formula:Please Login or Register to view this content.
Thanks
Kenneth
It may help if you upload a small desensitized sample of you data along with manually typed output that you want based on that data. To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks