Search results for query: *

just an update on this because i dont think i was very clear the part i'm having problems with is If i find a match to A1 in C3 how do i get it to copy the contents of D3 to B1

I know this will be easy for most of you but i cant seem to get my head round it this morning, I have column A filled with numbers and column C with numbers in it. I want to compare A with C and if it finds a match in the range fill column B with the contents of column D. Thanks for your help

Thanks Andy i thought that would be the case. I'll have a look. Matt

Hi Does anyone know away of tracing which extension an external call was picked up at ? think we have someone in the office hanging up on customers but not sure who! Thanks Matt

Hi i'm looking for a bit of help with this. We have a remote site connected to us via a router to router VPN connection, i can ping the DC from the remote site but is there an easy way to make sure it tries to log on to the DC when the user logs in ?

Hi We have an Office Serv 7200 and i'm trying to find a way to make several extenstion Internal only ie. Can't dial out of the building. I've been looking through the Manager but can't see anything. Is it possiable ? Thanks Matt

Afternoon all, This morning i have come into the office and 2 pcs on the first floor have no network connection, I checked all the cables back to the switch with a network tester and there all showing fine, I plugged another PC into the two ports that appear not to be working and it worked...

Sorted thanks by adding merging code&points so GOLD15 and running a VLOOKUP Thanks for your help.

I see the problem now i need a VLookup table so i have created this Code Points Value GOLD 1 £0.00 GOLD 2 £0.00 GOLD 3 £0.00 GOLD 4 £0.00 GOLD 5 £15.00 GOLD 6 £18.00 GOLD 7 £21.00 GOLD 8 £24.00 GOLD 9 £27.00 GOLD 10 £30.00 GOLD 11 £38.50 GOLD 12 £42.00 SILVER 1 £0.00 SILVER 2 £0.00 SILVER 3...

Thanks Des I just tried it with the GOLD only and if i run this =IF(E14="GOLD",IF(H14<5,0,IF(H14=5,2,IF(H14<11,2.5,IF(H14<16,3,IF(H14<21,3.5,IF(H14<26,4,IF(H14<31,4.5)))))))) It works but i needed one more on the end so added this...

Hi I'm trying to get a formula to work but cant seem to get my head round it this morning. I have a cell E14 with a list in it, Gold, Silver, Bronze I want cell E15 to look at it and which ever value is selected use a folrmula for it. Something like this...

Hi We have a remote warehouse that is connected to us Via router to router VPN, I've been looking at ways of letting it logon to the Domain over the VPN and have been told that a logon script should do the trick but can't find any information anywhere of how to do it, Could someone point me in...

Hi Not sure if i'm posting this in the right section but here we go. My server 2K server running SQL 2K and our Intranet was dying so i cloned the disk and moved it to a new machine. It came up fine and the Intranet which gets its stats from the SQL worked fine apart from its showing dates as...

We have exchange 5.5 and the directors have just got PDAs and want to pick up their email on them. Is this possible from 5.5 and if so can you direct me to any setup guide as i can't seem to find any info. Thanks Matt

Hi We have a site to site VPN using Netgear routers, Is there a way of directing the remote site XP Pro machines to the Domain controller for logons etc. ? Thanks Matt

Thanks guys i'll run it later and let you know.

LOL thks Mark its 2000

Hi Mark That worked thanks, but not as i was expecting, my orignal query result looked like. Rep_name ATP Leads ATP Sales Mr E Mann 4 4 What i was trying to achive is a field on the end called Ratio with the result of the extra query. Is that possiable ? Thanks Matt

Here is a select query i have, SELECT Tame_cust.Rep_Name, sum (Case Tame_cust.hlp_benefits When 'No' Then 1 Else 0 End) As [ATP Leads], sum (Case Tame_cust.hlp_benefits When 'Child Tax Credit (less than £14200pa)' Then 1 When 'ATT Allowance' Then 1 When 'Disability living Allowance' Then 1...

Just found the solution using XP_send in the FAQs