Excel Ranking - CR4 Discussion Thread

Home

Products & Services

Engineering News

Standards

Webinars

Engineering Forum

Login

CR4 Home | Software & Programming | Software & Programming

3 comments

Rate

Comments: Nested

Anonymous Poster	Excel Ranking 10/27/2008 12:23 AM
	So what I am looking for if there is one: the formula if I want to rank something but instead of ranking something 1st place, 2nd place, 3rd place, 3rd place, then 5th place. I want...1st, 2nd, 3rd, 3rd, then 4th. I keep finding formulas that apply a rank for tied scores but not one for my problem. Can anyone help me?
	Reply

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Join CR4, The Engineer's Place for News and Discussion!

Anonymous Poster	#1 Re: Excel Ranking 10/27/2008 12:38 AM
	Are you using Excel 2007? If so, this should work: =SUM(IFERROR(1/COUNTIF(RankRng,IF(RankRng<C3,RankRng)),0))+1 If you don't have 2007 - let me know
	Reply

Anonymous Poster	#2 In reply to #1 Re: Excel Ranking 10/27/2008 12:54 AM
	Oh yeah - I should have mentioned that that is an *array formula -* where you need to complete data entry with CTRL+SHIFT+ENTER and NOT just ENTER
	Reply

Anonymous Poster	#3 In reply to #2 Re: Excel Ranking 10/27/2008 1:00 AM
	I probably should have just given you this link in the first place: http://www.tushar-mehta.com/excel/newsgroups/ranking/#1
	Reply

You might be interested in: Electroceramics, Carbides and Carbide Materials (Hardmetals), Inorganic Chemicals and Compounds

	Got Something to Say?
	Ask a Question Start a Discussion

	Search this Forum
	Software & Programming: Go

CR4 Sections

	Aerospace
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education and Engineering Careers
	Electrical Engineering
	General Discussion
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering
	Transportation

	Site Directories
	Forum Directory Blog Directory User Group Directory RSS Feeds CR4 Rules of Conduct CR4 FAQ Site Glossary Who's Online (83 right now) Show Members