0

Multiple NL Rows Using Excel Range as Table Source

This should be simple but I'm rather new and wasn't able to find the answer through searching. I'm making a basic report that will show sales people by region using an Excel range as the table source. The desired layout is in the attached workbook but also presented below:

Region 1
Salesman 1

Region 2
Salesman 2
Salesman 3
Salesman 4

Region 3
Salesman 5
Salesman 6

Region 4
Salesman 7
Salesman 8
Salesman 9
Salesman 10

For the first formula, I have the rows function breaking out the sales regions, which works correctly. — =NL("rows=3",Data!$B$3:$B$6)

There is another NL rows formula (below) where I want it to show all of the names in the "Salesman" field, when the "Region ID" matches an adjacent cell. When I run the report it shows everything in the entire range, including the headers, regardless of what the region is:
=NL("rows",Data!$D$2:$E$14,"Salesman","Region ID",B4)

Do need to define the field headers? It seems to be ignoring the part where I only want the salesmen that match the region.

Any tips would be appreciated.

1 comment

Please sign in to leave a comment.