“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Want to find rank on excel for those whose pass in all subjects

Solved by B. Q. in 21 mins

I want to compare my data with normative values and rank as good fair poor etc. it also has to be aged matched. Can you help me with rank excel function?

Solved by M. C. in 15 mins

I need help with this in a pivot table/
Create a table that shows the average rank of the question, “Rank the following ice cream flavors.” Show the flavors on the side, and gender on the top of the table. Change the name of each flavor so that it only shows the name of the flavor and not "Average of [flavor name]."

Solved by F. J. in 22 mins

Hi,
I am looking for a way to easily track performances over different periods of time.
I pull data 4 times over the course of a day; however, peoples performance changes throughout the day so they are not always the same rank.
My idea is that I have 4 different tabs with the data in and on the 5th tab I have everyone's name down the left hand side and use a formula to find their data from the 4 different tabs so that it shows me the performance for the day at each time the data was pulled in one row.
Any help would be much appreciated!
Thanks

Solved by Z. B. in 16 mins

Location has buildings. Building has zones. For each location, find
1- top zone and
2- second rank zone
Ranking order is V, A, B, C, D (top to bottom)

Solved by O. C. in 27 mins

I have a workbook with three worksheets. On one worksheet is a list of data (data worksheet) with the top horizontal row listing security classes and the vertical left column a series of years (say from 1980 to 2016). On the second worksheet (rank) I have ranked the highest data value for each year (row). On a third worksheet (calculations worksheet) I have a series of rows (also from 1980 to 2016) with formulas in each row. Now, I want to use VBA code or macros to do the following: take the highest ranked security class for row 1980 from the rank worksheet, for that security class find 1981's data value (drop down one row (year) on the data worksheet) and put 1981's data value into the calculations worksheet into the row corresponding to 1981. Thus, I get a result from my formula for the year 1981. Then, I want to loop and find a result for 1982, etc. I have a beginner's knowledge of VBA and I would like to do this by running one sub routine.

Solved by B. L. in 24 mins

I have a workbook with multiple worksheets. On one worksheet is a list of data (data worksheet) with the top horizontal row listing security classes and the vertical left column a series of years (say from 1980 to 2016). On the second worksheet (rank77) I have ranked the highest data value for the year 1977 (row) and assigned the next year’s allocation per some predetermined logic. On a third worksheet (calculations78 worksheet) I have a series of rows corresponding to the classes of securities showing their assigned allocation percentages with formulas in each row. At the lower portion of the worksheet, I arrive at yearly return figure. Now, I want to use VBA code or macros to do this behind the scenes in one sub routine doing all of the years. The steps are the following: rank the returns in the first year, 1977, from the data worksheet, using my logic assign each an allocation, take that allocation to the Calculation worksheet for the next year and also find the returns for each Class for the next year, lastly, allow my formulas to calculate a yearly return. Finally, I carry the return to a Summary worksheet. Then, I want to loop and find a result for the next year. I have a beginner's knowledge of VBA.

Solved by Z. Y. in 11 mins

I have win/loss columns for player stats and I need help using rank and percentile data analysis tool......I want to be able to pull up the player name using vlookup next to the rank and percentile table but I don't know how to do that; please and thank you!

Solved by K. S. in 11 mins

Need help with vlookup function and can you help me with how to calculate percentile the data analysis tool

Solved by X. J. in 30 mins

I have for product that can be either high medium low and that the customer status should follow the high rank if it the customer is high and the other three groups rank between high medium low result should be high if customer medium used product high rank high can any one advice
=IF(D20>=76%;"high";IF(G20>=75%;"Medium";IF(J20>=74%;"Low";IF(M20>=75%;"Medium";IF(D20>=G20:J20:M20;"high";"high";IF(d20>=g20:j20:m20;"medium";"medium";IF(m20>=g20:j20:m20;"low";"low"))))))

Solved by C. E. in 27 mins