Analyze data from a name-date-availability sheet

I have an excel sheet that displays dates (ex. 02-07-17) in a horizontal column and a namelist in a vertical column. The created table is filled with a mark "x" whenever a certain name will be present on a specific date. The names will always be present between the first and the last "x".
What i'd like to do is to write a formula that will give me the name and the first and last date for which the person will be present in a single box.
This is to eliminate the need to crossreference each date by hand each time.

Any help would be greatly appreciated!!

Code (VBA) or a formula?

Will you please attach a sample Excel workbook?

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Here is a method that uses an array formula to get the nth column with an "x." You can combine the formula if you wish. I left it as a series of helper columns.

Count: =COUNTIF(3:3,"x") - gets the number of x's in the row
First Column: =INDEX($A$2:$L$2,1,MATCH("x",3:3,0)) - uses match / index to find the first date
nth Column: =INDEX($2:$2,1,LARGE(((3:3="x")*COLUMN(3:3)),COUNTIF(3:3,"x")-C22+1)) - entered as an array formula - similar to the above but gets the nth time the date appears in the column where n is the value in the count column.

I am not sure what the question is. Check what you have in the INDEX part of the formula - the first argument (the range) should be "fixed" to the rows containing the date.

Attached is the spreadsheet with the formulas moved up to the rows with the names. I had to modify the COUNTIF formula to avoid a circular error.