Posted to microsoft.public.excel.worksheet.functions

Dave

external usenet poster

Posts: 1,388

Nesting if/or/and

Hi,
Not sure if I fully understand, but here's a suggestion -
I think I'd use COUNTIF to determine the ties. eg:
=IF(COUNTIF(I7:I37,I8)1,"Tie","")
Then use RANK to determine the place, eg:
=RANK(I8,I7:I37)
Combination would be:
=IF(COUNTIF(I7:I37,I8)1,"Tie",RANK(I8,I7:I37))
Is this close to what you're after?
Regards - Dave.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nesting	LWilson	Excel Worksheet Functions	12	May 9th 08 08:43 PM
Nesting	Donna	Excel Worksheet Functions	8	April 3rd 08 08:05 PM
OR Nesting?	Karel	Excel Discussion (Misc queries)	2	March 27th 08 03:52 AM
IF - Nesting... almost got it - need a bit of help	AngelaG	Excel Worksheet Functions	1	August 22nd 05 10:30 PM
nesting sum if and	BMSpell	Excel Worksheet Functions	2	January 20th 05 05:10 PM

All times are GMT +1. The time now is 10:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us