15th Anniversary of MrExcel.com - Free Excel Tip Cards for All

[Smitty]

She will need to adjust the number of posts too

I think your post count is high enough there pal.

 

[narendra]

Congratulations!!!

Thanks for the tipcards and for sharing wonderful information on this website.
Wishing u and the MrExcel team all the best

 

[mancubus]

15 years.

CONGRATS...

and starting with MrExcel, thanks to all who contributed to the excellers worldwide.

 

[MrExcel]

Smitty -

No work today due to the holiday, so a little web scraping, VBA, VLOOKUP, and pivot tables generated some stats from the previous incarnation of the MrExcel board.

For info on the earliest members of the community, check out this post: http://www.mrexcel.com/forum/lounge-v-2-0/742290-early-days-mrexcel-board.html#post3647644

Bill

 

[northrops]

Great cards. Just 1 question...on the vba card it says =R1C13 refers to $M$13 Should that be =R13C13 or am I misunderstanding?

 

[MrExcel]

Right - that appears to be a typo.

 

[AlphaFrog]

Great cards. I like the shortcuts. Thanks. (I'm usually late to the party.)

Another typo if you're interested.

ExcelFormulasTipCard.pdf

3rd Smallest Value: =MIN(A2:A99,3)

Should be SMALL.