Hi all just thought i would post this which could be handy for those who use Excel .... as i have seen post where people work out things for there robot projects in excel.
At the moment im upskilling to try and get myself a job ... and as i love excel decided to learn more about it so have being teaching myself while i wait on my advanced excel course to start. Great excel site i found is this http://chandoo.org/wp/ and while using this site i have started learning about VB code and macros. And after discovering its not to difficult to create a macro that will automatically put your formula into a cell so you dont have to type it in every time you start a work book i was suddenly struck with another way of doing it .... as a lot of people dont like work books with macros as they dont understand macros or Visual Basic code.
It struck me what if i used the Auttocorrect feature ..... if you go to autocorrect (windows 7 ... hit Menu button ... go to excell options.... proffing and click autocorrect .... ) here you can type in words and have them replaced by other words ... eg if you type in jl and in next section type in John Long ... when you type jl in excel or word and hit space or enter it changes to John Long ... this saves time
well what if you type in find1 and in other section type in =INDEX(A12:A21,MATCH(LARGE(C12:C21,1),C12:C21,0)) ....
yes it dose work .... when you type find1 in excel and hit enter it changes to your formula making it a SUPER QUICK way of writing your most used formulas ... all you need to do then is adjust your cell references ... easy peasy lol.
anyway thats it .... i think i might be the first to discover this ... but it sure will save me a lot of time ... hope it speeds things up for those of you who use excel.