Excel formal
- or -
Post a project like this2164
$$
- Posted:
- Proposals: 6
- Remote
- #1997327
- Awarded
Programmer,Microsoft Office expert, Content Writer, Electrical Engineer,Graphic Designer,Video Editor, Logo Designer, Freelancer, Excel Expert
Islamabad
694576201414709829196367920264182196469
Description
Experience Level: Intermediate
I need some help with excel formulas. If you have availability today, please submit a proposal.
I currently have a workbook that pulls various pieces of information from individual tabs into a Workings Tab.
In the Workings Tab, this information creates a table that has to be sorted in order using the data in the last column I have created formulas that sorts this information automatically into order of highest to lowest percentage, which changes automatically as and when the Individual Tab entries change are updated.
This works perfectly well until I have entries with the same percentage figure.
For example: If three entries, say Red 85%, Blue 85% and Green 85%, it appears in my table a Red 85% on three rows and Blue and Green do not appear.
I need this doing as soon as is possible.
I look forward to hearing from you,
Kyra
I currently have a workbook that pulls various pieces of information from individual tabs into a Workings Tab.
In the Workings Tab, this information creates a table that has to be sorted in order using the data in the last column I have created formulas that sorts this information automatically into order of highest to lowest percentage, which changes automatically as and when the Individual Tab entries change are updated.
This works perfectly well until I have entries with the same percentage figure.
For example: If three entries, say Red 85%, Blue 85% and Green 85%, it appears in my table a Red 85% on three rows and Blue and Green do not appear.
I need this doing as soon as is possible.
I look forward to hearing from you,
Kyra
Kyra D.
100% (25)Projects Completed
16
Freelancers worked with
15
Projects awarded
67%
Last project
7 Apr 2020
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies