John()
Member
Hi all i have attached a sheet with a formula i came accross in the forum the other day ... what i would like is for you to find another formula to do exactly the same thing and also to be shorter(formula length is 204 characters)
you can create a totally different formula or use part of the original formula (as maybe using part of the original is the only way to do this)
BUT YOU CAN NOT USE ... INDIRECT
Ok why do this ... well i have being working hard the last few months learning all i can about spreadsheets and my favourite part is formulas and understanding and trying to break them down to figure out how they work. One thing i learned is the better you understand individual functions the easier it is to break down formulas.
I found this to be a very interesting formula and works great ... but while trying to break it down i got confused over the INDIRECT function and it made things a bit tricky .... which led me to come up with anothe way of doing it which did the same job ... and today while revewing my formula i realised i used parts of the formula that i didnt need in my version so trimmed it down to 148 characters.
so i thought it would be nice to challange you to do the same and create or adjust this formula to do the same job without using indirect and see what you come up with. And see would anyones finished formula resemble what i ended up with.
I also figured out his use of indirect ... i just hadnt had much experience using this function and threfore didnt understand it enough at the time. so now i learned how to use this function better.
Anyway hope to see a few attempts at this ... will post my formula in a few days and hopefully will have some of your attempts to compare it too.
you can create a totally different formula or use part of the original formula (as maybe using part of the original is the only way to do this)
BUT YOU CAN NOT USE ... INDIRECT
Ok why do this ... well i have being working hard the last few months learning all i can about spreadsheets and my favourite part is formulas and understanding and trying to break them down to figure out how they work. One thing i learned is the better you understand individual functions the easier it is to break down formulas.
I found this to be a very interesting formula and works great ... but while trying to break it down i got confused over the INDIRECT function and it made things a bit tricky .... which led me to come up with anothe way of doing it which did the same job ... and today while revewing my formula i realised i used parts of the formula that i didnt need in my version so trimmed it down to 148 characters.
so i thought it would be nice to challange you to do the same and create or adjust this formula to do the same job without using indirect and see what you come up with. And see would anyones finished formula resemble what i ended up with.
I also figured out his use of indirect ... i just hadnt had much experience using this function and threfore didnt understand it enough at the time. so now i learned how to use this function better.
Anyway hope to see a few attempts at this ... will post my formula in a few days and hopefully will have some of your attempts to compare it too.