There's lots of Q&A websites out there talking about Excel bugs that are actually formula errors, and others that talk about recursive VLOOKUPs when they really mean iterative. To be clear on what we are talking about: Excel (2007, 2010, 2011) has an undocumented feature where you can use circular reference in the third argument of VLOOKUP without iterative calculation.
Why should I care?
Here's one type of problem you can solve with this "feature". Suppose we have an organizational chart and want to find how many levels deep each person is. Similar to this problem posted on MrExcel.
IDBOSSNAME1John Smith21Susan Jones32Alice Johnson42Tim Moore51Rachel Parker61Tom Allen75Michael Gross85Kim Dole96Kathy Roberts106Betsy Foster1110Mini Foster
You can do it with this in cell D2:
I have been trying to get involved in the FICS project, the largest and oldest free online chess server. After playing for many years there, maybe there is something I can give back.
It would be nice to know more about their organization and who the real people involved are. Even though there are so many people actively playing there, information about the project is sparse and dated, and I can get in contact with any admins via email. Investigating further, I have the following to share.
The entity that owns and operates the FICS (or used to) is Free Internet Chess Organization, a Minnesota corporation. Their original address was:
P.O. Box 3212 Burnsville, MN 55337
While operating out of
13306 Court Pl Burnsville MN 55337 USA
But is now
8708 31ST Ave N New Hope Mn 55427
Originally the FICS was registered as a non-profit on 07/31/1998, however the entity has been dissolved as of 01/16/2007 according to the State of Minnesota.
So, at this point donations are not tax deductible.