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
--
Traa Dy Liooar

Jock

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

That'll do nicely. Thanks Debra
--
Traa Dy Liooar

Jock


"Debra Dalgleish" wrote:

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