I have 1 more question

Now have the 20 cells populated.

I then created another row with the 10 lowest from the 20 (figured that one
out my self!)

I now want to create an if statement to put an astrick under the 10 lowest
cells in the row of 20.

The formula I used was (this is for row 51)
=IF(C49=50:50,"*","") Note row 49 contains the formula you provided to
select 20 and row 50 is the ten lowest of the 20

But this will only put an astrick under the cell that is equal to the one
above it. What I want is for an astrick for all cells in row 49 that have a
cell equal to one of the 10 cells in row 50


"T. Valko" wrote:

OK, assuming there will *always* be at least 20 entries in the range...

I'm using row 1 in the example.

Array entered**

=INDEX(1:1,LARGE(IF(1:1<"",COLUMN(1:1)),20-(COLUMNS($A:A)-1)))

Copy across to a total of 20 cells.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Larry L" wrote in message
...
Assuming the original row has 20 cells with data
I would like the new data to be 1,2,...19,20

When an additional cell is added to the original row I want the new data
to
be 2,3,....20,21

Ocassionally the original row may have a cell that does not have data, in
that case
I want the new row to look at additional cells so that it will always have
all the non blank cells up to 20,

"T. Valko" wrote:

What Gary meant was this:

Assume this is your data:

1 2 3 4 5

Do you want the result to appear as:

1 2 3 4 5

Or:

5 4 3 2 1

--
Biff
Microsoft Excel MVP


"Larry L" wrote in message
...
The most recent will be last in the new row.

"Larry L" wrote:

I want the most recent retained -- so the formula needs to consider
data
from
right to left in the row.

"Gary''s Student" wrote:

Do you want the order retained or reversed??

That is, most recent first or most recent last?
--
Gary''s Student - gsnu200827


"Larry L" wrote:

I would like assistance with a formula to accomplish the
following:
From a row of data I would like to generate a second row that
contains 20
nonzero cells from the original row of data beginning with the
cell
working
from right to left. Note: I will be adding data to the original
row
and would
like the formula to regenerate a new row considering the new data
and
dropping off data that is more than 20 nonzero cells to the right
of
the last
entry.