Filtering on calculated data

**Guntruck** · 01-06-2010, 10:17 AM

Hi folks,

Hope someone might be able to shed some light on a filtering problem I have.

I want to filter on a column of data that has been calculated using the NETWORKDAYS function to determine the number of days between two dates. I use the custom filter for getting records where the number of days is less than or equal to 15. This works fine the first time it is used, but subsequently it returns no records. Frustratingly this works OK on my PC and only became apparent on a few other PCs used for testing.

I've attached a subset of the worksheet to illustrate the problem. Column A contains the calculated days, and I've added Col D which are straight values only. The filter works fine on this column.

If anyone has any idea why this is not working and/or a possible work-round, it would be greatly appreciated.

Cheers!

Steve

**Guntruck** · 01-06-2010, 10:20 AM

Obviously it helps if I attach the attachment......

**NBVC** · 01-06-2010, 10:29 AM

It seems to work ok with me.

Maybe you can try giving the Holiday range a name via Insert|Name|Define and then use that in the formula instead... that may be causing the problem.. but am not 100% sure...

**Guntruck** · 01-07-2010, 05:37 AM

Thanks for that, unfortunately this hasn't solved the problem. Interesting that you got it to work - seems to be a prob that occurs with some computers and not others.

Steve

**Guntruck** · 02-04-2010, 07:05 AM

Problem solved! Some PCs using this spreadsheet did not have Analysis Toolkit installed. This now works perfectly on everybody's machine.

**NBVC** · 02-04-2010, 08:37 AM

By the description of your problem... i.e. you said after filtering it goes bad and the first time is okay.. I wouldn't have mentioned the Analysis Toolpak. Not having the analysis toolpak would return #NAME error. If you had mentioned that, then it would have been a great clue.