Search results for query: *

Hi Peter, The VPN is using a Netscreen/Juniper Firewall/VPN and its associated VPN software. I'm starting to suspect that the way the Netscreen has been configured may be an issue. I'm going back to the guy that set that up. On the one laptop that does work, I've tried a different user, and it...

Here's the brief summary: Server 2003, 4 HP laptops, setup from an image. Firewall/VPN is a Netscreen, client compters are using the netscreen client software to connect the vpn. Laptops running XP Pro. Laptops are joined to a domain, with mapped drives. What I want to be able to do is access...

Thanks Ken, That's so simple and obvious, once you know! I'll look into pivot tables too. Thanks everyone for your help.

Thanks Dhulbert, That does most of what we want, and certainly is a large step in the right direction. Is it possible to make it so that it will only give 1 value (ie the total) for each job number. If I extend the formula down the whole sheet, the first value it gives is the grand total for...

Thanks Dhulbert, That does most of what we want, and certainly is a large step in the right direction. Is it possible to make it so that it will only give 1 value (ie the total) for each job number. If I extend the formula down the whole sheet, the first value it gives is the grand total for...

2536710 5/7/04 6.00 2536710 5/7/04 6.00 12.00 2537730 17/1/05 6.00 6.00 2537735 5/7/04 2.00 2537735 19/9/04 2.00 4.00 Here's the story. We have a large spreadsheet that does job costings. The 1st column is the job number, 2nd obviously is date, the 3rd is the rate for the job and the...