Hey everyone, my name's benishiryo & i am an Excel addict... it's almost 2 years i've been in this forum & although I've only been helping only since about Apr 2012, i've learned more than i can ever imagined. So i'm sharing all (well, most. ok maybe just stuff i bothered to note down when i'm not being lazy) the stuffs i've learned in this 1 year. it may be an overkill for some to have so many things inside though.
a big thank you to all OPs i've helped because cracking my brains for you guys made me learn things through it. and definitely mostly due to contributors here i've learned from. i'm soooo much better than i was a year ago & i'm not even close to being awesome yet.
credited some of the tips to the people who provided the solutions, but this started later when i thought it would be more appropriate when sharing. So i'm sorry if some of the solutions were from you & i missed your name. If this file proves useful or if this thread becomes "stickied", i will then keep updating it.
Edit: Will constantly be updating the opening post (so no notification if you have subscribed to this!) instead of a new post whenever I have updates, so keep a lookout for the date in the file name if you guys are interested. Explanations written inside the file are done by me, with the exception of 1 case where I asked Ron Coderre about a portion of his amazing formula & he helped explain. i hope the new layout is easier for users to find what they need. i guess i need to categorize them but it's kinda tough. just keep a lookout for this on a monthly basis. i'll try to do updates