I have five columns of book names. I am looking for a formula that will record the name of any book that is in all 5 columns in the 6th column. 

Currently I am able to do it for two columns using the below but I am having trouble extending it to multiple columns and setting a minimum threshold on it. 

```
=IF(ISERROR(MATCH(A4,$B$4:$B$329,0)),"",A4)

```

If anyone can help it would be much appreciated

**Data:**

```
A             B             C            D            E

Book 1        Book 1        Book 1       Book 3       Book 1
Book 4        Book 2        Book 2       Book 23      Book 4
Book 6        Book 5        Book 5       Book 14      Book 23
Book 9        Book 22       Book 3       Book 2       Book 17
Book 3        Book 6        Book 7       Book 6       Book 2
Book 7                      Book 27      Book 14      Book 15
Book 2                      Book 6       Book 4       Book 6
Book 23                     Book 13      Book 66      Book 9
                            Book 34      Book 32
                                         Book 17
                                         Book 18

```

**Expected Result:**

```
A             B             C            D            E            Answer

Book 1        Book 1        Book 1       Book 3       Book 1       Book 1
Book 4        Book 2        Book 2       Book 23      Book 4       Book 6
Book 6        Book 5        Book 5       Book 14      Book 23
Book 9        Book 22       Book 3       Book 2       Book 17
Book 3        Book 6        Book 7       Book 6       Book 2
Book 7                      Book 27      Book 14      Book 15
Book 2                      Book 6       Book 4       Book 6
Book 23                     Book 13      Book 66      Book 9
                            Book 34      Book 32
                                         Book 17
                                         Book 18

```

The alternative would be to highlight all values that appear at least 5 times.