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 usingin 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.
Please Login or Register to view this content.
Is there a way to have the order reversed. In other words the number goes to 17, 16, 15 etc?
Thanks
Last edited by Johnmus; 09-12-2011 at 03:56 PM.
Try
Does that work for you?Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks