Copying formula down with reverse numbers

**Johnmus** · 09-12-2011, 03:53 PM

Hi Everyone,

I am setting up an awards sheet with many classification and the order of awards is from lowest to highest placement.

I am using

=IF(ISBLANK(Aux!18)," ",Aux!18)

in the first classification but when I try to copy this down the number of course goes up to 19 etc.So I have to manually type in all the references.

Is there a way to have the order reversed. In other words the number goes to 17, 16, 15 etc?

Thanks

**ChemistB** · 09-12-2011, 03:59 PM

Try

=IFERROR(IF(ISBLANK(INDIRECT("Aux!Y"&19-ROW(A1))),"",INDIRECT("Aux!Y"&19-ROW(A1))),"")

Does that work for you?

**Johnmus** · 09-13-2011, 03:10 AM

That works great, except I am using ISBLANK to hide unnecessary rows. I some cells that are referenced there will be a #NUM! - for example when the rankings are 0 through 15 - and in those instances the row will not hide. Is there a way around this?

Thanks for your assistance!