Safdar Ansari
New Member
- I've got the challenge in my excel work
- called the Bacon challenge. The goal of this challenge it to calculate an actor's Bacon number.
- This puzzle is defined as follows:
- Kevin Bacon has number 1 and everyone who has ever played in a movie with Kevin Bacon, like Ed Harris in Apollo 13, have Bacon number 2. Everyone who has played in a movie with Bacon number 2 have Bacon number 3.
- Attached a spreadsheet contains a list of actors, a list of movies, and a list of actors
- who have played in movies.
- So, the challenge is to make a spreadsheet formula in such a way that the Bacon number is calculated automatically.
- It has to be a formula that automatically calculates it. If we add new movies or if we add new actors, it should update itself.
