URLs http://www.mcli.dist.maricopa.edu/tut/tut10.html and http://www.cs.tut.fi/~jkorpela/HTML3.2/3.10.html are the two locations I did NOT easily find about this HW #1 issue for your job interview question.
And what if you wanted the © or the ® symbols to show up on your web page?
The updateCounts() Subprogram SUB was as follows.
Sub updateCounts() hadRepeat = False For r = 3 to 24 If Cells(r, 2).Value = "Repeat" Then hadRepeat = True End If Next r If hadRepeat = True Then Range("F2").Value = Range("F2").Value + 1 End If Range("G2").Value = Range("G2").Value + 1 End Sub
See and study the following web page to review the Visual Basic for Applications (VBA) Birthday macro basics. The VBA code is EXACTLY THE SAME for Excel 2007 VBA and Excel 97 (1997) and Excel 2003 VBA. You need to use Internet Explorer web browser to see the slide show on the Birthday macro. The 23 birthdays problem as an introduction to Microsoft Excel VBA macros is a link from that page..