You could apply an AutoFilter to the table (DataFilterAutoFilter).
Then, in column C, select Custom from the AutoFilter list
Select 'is greater than' in the dropdown list, and type 6 in the text
box, then click OK
The list will show only the rows with networkdays greater than 6

Jock wrote:
I have a column (C)which, using NETWORKDAYS, gives me the difference, in
days, between two dates in columns A & B.
Using this result, how can I have excel automatically list which cell(s)
contains data outside a set criteria of 6 days?
Given that the data I'm working with may have up to 5000 rows, I'd like the
results in a small table on a seperate worksheet.
tia


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html