You can change the style the forum displays by selecting your preferred style at the bottom left of the site.
We have made an enhancement so that old threads should now link from search results to the correct thread. This is not yet in place for single post links
Hi, I know a few people on here are into thier computers and software, i really need help with excel. It really getting on my nerve i wish to do one function, which if i was microsoft i would have a button for but they arent in the real woorld so we have to do it manually! Is anyone here an advanced user of excel and can give me help on the autofill fucntion!
Regards Michael
Sorry i forgot to say the fuction i wish to achieve.
I wish to enter any number into a certain cell and then some where else on the worksheet it will populate the cell from 1 to that number.
eg
i put the number 3 in cell H1 and from cell B5 it populates downwards 1,2,3 down the column.
Please if anyone has any ideas i will try it, god knows ive tried everything else!
Question/Rant over
Thanks Mike
Sorry i forgot to say the fuction i wish to achieve.
I wish to enter any number into a certain cell and then some where else on the worksheet it will populate the cell from 1 to that number.
eg
i put the number 3 in cell H1 and from cell B5 it populates downwards 1,2,3 down the column.
Please if anyone has any ideas i will try it, god knows ive tried everything else!
Question/Rant over
Thanks Mike
Hi there
Just try keying in the formula you wish tou express, i.e. =B5+1
John T
2001 A6 1.9 TDi SE (130) RS2 or S2 Next on the shopping list :mischeif:
Paul your a star! How simple when you know how! I'm using for a simple calculator for when the best time to make a pit stop is depending on fuel consuption per lap, number of laps, etc.
Thankyou
No worries - I can hold my own with Excel - Just don't ask me about pivot tables...
Make sure and do this with fuel measurements by weight if you are doing this for the real world - its much easier to manage than volume. Apologies if you know this already.
I did do it by weight, now it's just debugging the calculations, is there a way to do an if test for only if it's true will it do a function if it's false do nothing, not just put " ". cos on some i keep getting circular refrences or it's trying add " " to a value. Regards Michael.
It's ok i seemed to have solved the problem, just instead of putting " ", i put 0 seems to work. Doesnt look as neat but well i can tidy it up this only to data sheet, i can refrence all the important figures later.
Once again Thanks
Mike
I am using Excel daily for all sorts of functions - but if you are struggling to get it to show a tidy cell for null values, you can always set up a conditional format so that values of more than 0 are shown with black writing on a white background (or whatever colours suit) and all zero values are shown with the same colour for text and background (so they are invisible).
Martin Cutting
aka Keeper of "The Teutonic Kitten"
It's not better than sex, but it runs it a close second.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment