LinkBack URL
About LinkBacks
was wondering if there was a way to consolidate fomlua such as:
to be much shorter.... i use several of these on my sheet but only the "Light-Bearer" changes, please any help would be great
Please Login or Register to view this content.
was wondering if there was a way to consolidate fomlua such as:
to be much shorter.... i use several of these on my sheet but only the "Light-Bearer" changes, please any help would be greatPlease Login or Register to view this content.
Formula:
Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Oh, Light-Bearer changes, missed that.
Formula:Please Login or Register to view this content.
Put Light-Bearer or whatever you want in cell D6.
works like a charm now just have to change all the statements i have already put in, thanks
If you put in some dollar signs to prevent the range from moving you can just copy the formula down.
Let's say you put this formula in E6. Then put Light-Bearer in D6, Dark-Bearer in D7, Heavy-Carrier in D8 and so on.
Then select cell E6 grab it in the lower right corner of the cell and drag down. It will copy the formula, the $C$22:$C$71 range will stay the same but the D6 will change to D7 and so on.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks