Reverse A List in EXCEL

Question

Hi Guys I have a list that is populated via formula so the amount of rows requiring to be reversed actually varies.

    **E**

Now from Cell E35 to Cell E1007 the value is "-" for this example.

Depending on the input information which cell the "-" will start in will vary.

What I have done is just created another column and populated

CELL X8 with =E1007

CELL X9 with =E1006

CELL X10 with =E1005

and so on down to

CELL X1006 with =E9

CELL X1007 with =E8

But this then gives me a long list were the 1st 900+ Rows are "-".

Is there a way were I can make this list contain only the one "-" so as to look like.

And the cell with "-" to start in ROW 8, and then ROW 9 would contain the value L1M16, instead of how it currently is done were L1M16 is actually in ROW 980.

Hope that makes sense and appreciate the assistance.

I am using EXCEL 2013

Regards

mbart67

Answer 1

Couldn't get that formula to work either. Two zeroes and then only hyphens. Perhaps, Dighi can demonstrate how it works on his side!

Now, I don't have Excel 2013 anymore so can't test the formula below, but it I believe it should work. (Will try to get my hands on this ancient version though).

=IFERROR(INDEX($E$8:$E$1007,MATCH("-",$E$8:$E$1007,0)+ROW($E$8)-ROW()),"x")

Enter it in X8 and copy it down until you get to an "x". It should produce a list starting with one hyphen followed by the last value above the first hyphen and then work its way up the original list.

Answer 2

Thanks Riny_van_Eekelen,

This worked real well and did not seem as resource intensive.

Regards

mbart67