Summarising data into a table

J

Jock

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
 
D

Debra Dalgleish

You could apply an AutoFilter to the table (Data>Filter>AutoFilter).
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
 
Top