Join 3,370 readers in helping fund MetaFilter (Hide)

2 posts tagged with formula by Conrad Cornelius o'Donald o'Dell.
Displaying 1 through 2 of 2.

Related tags:
+ (45)
+ (25)
+ (11)
+ (11)
+ (7)
+ (5)
+ (5)
+ (4)


Users that often use this tag:
malcommc (3)
anastasiav (2)
Conrad Cornelius o... (2)
Anonymous (2)
Vorteks (2)

Using Excel Formulas to Rank Ordered Lists

Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Mar 6, 2010 - 8 answers

Excel: Incrementing Formula Row Copied Across Columns

Excel question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2009 - 12 answers

Page: 1