Prev: Pivot Table- Column 2 sort
Next: Data Connection between Excel 2007 and SharePoint 2007
From: Rick Rothstein on 21 Jan 2010 03:54
If your ranges were all of equal length, you could do it with a simple
formula, but I'm guessing your ranges are not of equal size because you
can't start the way you show (starting at I,H and end up at A) given 0 to
0.25 is I and 0.26 to 0.50 is H. Can you show us all of your actual ranges
and their letter assignments?

--
Rick (MVP - Excel)


"Reno" <Reno(a)discussions.microsoft.com> wrote in message
news:B9A07F7B-AF46-41DE-8E19-F53F56363C20(a)microsoft.com...
> want to assign a letter or number based on calculated value (much like a
> grading scale.) If calc value is:
> .0 to .25= I
> .26 to .50= H
> .
> .
> .
> final one >5.1 =A
>
> can you do as an array beside doing the If > and < formula
> thx

First  |  Prev  | 
Pages: 1 2
Prev: Pivot Table- Column 2 sort
Next: Data Connection between Excel 2007 and SharePoint 2007