# Get instant live Excel expert help to learn how to rank in Excel

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

i want minimum value from below rank by excluding number 1 Rank 17 1 6 2 4 8 7 1 1 4 7
Solved by I. D. in 13 mins
You have been asked to rank your company's customers. "A" customers bought more than \$750,000. "B" customers bought more than \$500,000. "C" customers bought \$200,000 or more. "D" customers bought more less than \$200,000. Use this information to create
Solved by V. D. in 15 mins
I am trying to figure out how to create a formula that will allow me to easily transfer data from ‘Text worksheet B’ to the ‘Test master’ sheet. I want the programs listed in column B of the ‘text worksheet B’ to be transferred to the columns M, N, O, etc in the ‘test master’ sheet for the corresponding person (ie person A, person B, etc). The programs should be listed in columns M,N,O, etc of the ‘test master’ sheet based on their rank in column D of the ‘text worksheet B.’ For instance, Program E for Person B in the ‘text worksheet B’ should be populated in the cell P3 on the ‘test master’ worksheet. Make sense?
Solved by E. B. in 29 mins
I cannot enter this formula into Excel. I get an error message asking for an apostrophe?IF(\$S2=0,"",IF(\$S2>0,RANK(\$S2,\$S\$2:\$S\$8000),RANK(\$S2,\$S\$2:\$S\$8000-COUNTIF(\$S\$2:\$S\$8000,0)))
Solved by B. W. in 25 mins
I would like the program names from column C in sheet 1 to be placed in columns AC, AD, etc in sheet 2. These programs should be placed in the columns of sheet 2 based on the rank they are listed for each person in sheet 1, column G. For example, person 1 should have program A listed in cell AC2, program B in AD3, etc in sheet 2. I think we are close and the formula I was given yesterday is below. But my actual data is contained on 2 separate sheets. Here is the formula: • =IFERROR(INDEX('Text worksheet B'!\$B\$2:\$B\$500,MATCH(1,(\$A2='Text worksheet B'!\$A\$2:\$A\$50)*('Text worksheet B'!\$D\$2:\$D\$500=COLUMN(M\$1)-COLUMN(\$L\$1)),0)),"")
Solved by G. W. in 21 mins
Produce the metric PTG, OPTG, and rank for each month (May, June, July) • Provide the ratios of those meeting and not meeting for each metric • Provide a SQL script example from the May data set that would provide the following items o Retrieve the average iOCR, Trans/Conf, UP, DDC, and NPS for the entire group
Solved by I. J. in 26 mins
I'm looking for the formula for OPTG (overall percent to goal), PTG (percent to goal) and rank for each month (May, June, July).
Solved by I. Q. in 18 mins
Third table: Prepare some form of a lookup that returns the names that appear on both lists. For each name prepare a lookup that returns the rank of the name on both the male and female lists.
Solved by I. F. in 22 mins
I would like to insert a rank on my filter page table
Solved by X. H. in 23 mins
Prepare some form of a lookup that returns the names that appear on both lists. For each name prepare a lookup that returns the rank of the name on both the male and female lists.Hint: There are only 331 names that are common between males and females. Use a combination of the functions SMALL and LOOKUP and VLOOKUP.
Solved by I. E. in 15 mins