How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Michael Hannigan Your Own Question

Michael Hannigan
Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 11154
Experience:  25+ Years Experience in Computers and Electronics. Microsoft Certified MCSE, MCDBA, MCP, Microsoft Partner
23511658
Type Your Microsoft Office Question Here...
Michael Hannigan is online now
A new question is answered every 9 seconds

I have a list of 15 mutual funds, in Excel, 401-k selection.Inf

Customer Question

I have a list of 15 mutual funds, in Excel, for my 401-k selection.
Info on each fund as follows:
qtrly return
YTD return
1 YR return
3 YR return
5 YR return
10 YR return
Life of Fund return
I need someone to create Excel sort function to sort funds for highest overall return based on the above info.
Thanks
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Michael Hannigan replied 1 year ago.
Hello. My name is***** can help you with your question. If all you need is to sort by a particular column like the return since the inception of the fund, as long as you have that in one of the columns, you can highlight that column and then click on sort. Then it will sort by that column. You don't really need a special programming for that. However if the calculation you are doing is more complex than that, I can help you out with it. Some me know. Mike