View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Summarising data into a table

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