Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zircom

    UK 3902 in the USA

    Hi, in desperation we have to send some 3902's to the USA, can we use them with a different firmware or is it a waste of time?
  2. zircom

    Awarding prizes in column 'D to list of scores in a column 'C'

    i am wanting to award different amounts = £50, £40, £30, £20 ties share the 2 places thanks
  3. zircom

    Awarding prizes in column 'D to list of scores in a column 'C'

    hi, i want it to do the winnings automatically. Ie: once all the scores are in Column 'D' is completed by a formula as to who has one what. I assume i am going to have a table some where as well. Thanks
  4. zircom

    Awarding prizes in column 'D to list of scores in a column 'C'

    Hi, i have the follwing and wish to award a value to the highest points for the top 4 Col 'A' Col 'B' Points Prizes 23 € 0.00 35 € 0.00 33 € 0.00 28 € 0.00 38 € 0.00 18 € 0.00 22 € 0.00 27 € 0.00 30 € 0.00 30 € 0.00 36 € 0.00 40 € 0.00 Thanks
  5. zircom

    CS1K DPNSS call forward form Mitel

    Has anyone know of a solution to the following: CS1K linked to a Mitel SX2000 via DPNSS, when a phone on the Nortel is call forwarded to an external number and that phone is rang from a Mitel phone the call fails due to 0 being dropped (the mitel access code is 0 for external calls) so a...
  6. zircom

    Formula for indicating work rates

    sorry. i have another sheet which has a total field which these should look at that gives a running total of productivity
  7. zircom

    Formula for indicating work rates

    sorry not a good explanation: A B C D 1 Name Rate Diff Move to next per 2 Kevin 235 39.5 274.5 3 Fin 314 15 329 4 Pete 344 52 396 5...
  8. zircom

    Formula for indicating work rates

    Hi, i need to find a formula that calculates the following: TOTAL NUMER OF PARALLELS COMPLETED Name Rate Diff Move to next per Kevin 235 39.5 274.5 Fin 314 15 329 Pete 344 52 396 Charley 448 10.5 458.5...
  9. zircom

    comparing 2 columns to find matches

    great response and they worked, i used a couple of them in the spread sheet to show a sanity check process. thanks again
  10. zircom

    comparing 2 columns to find matches

    I need to look at 2 columns: 'A' 'B' 'C' 2345 2345 Y 4567 4568 Y 4568 6789 N 7890 7890 Y Etc (3,500 numbers) and i need to see which ones in column 'B' are in column 'A'. THanks
  11. zircom

    Comparing fields to produce another result

    I am having trouble getting a result from 2 database views. IV00102.LOCNCODE (this view is Inventory) holds a field with stock location and Qty's ie: ENG12G SVC00100.LOCNCODE (this view is Service) holds the same info and in the same database view is SVC00100.NAME which hold the actual name...
  12. zircom

    Stopping Explorer in XP from using a session already active

    I need to stop Internet Explorer in XP from trying to use a session already active. If already running a web based application (Sharp Owl) and then if I click on a link in an email it is trying to use the already open Sharp Owl screen which I do not want it to do for variuos reasons. Thanks
  13. zircom

    Adding Bitmaps

    I have a data file of bitmaps with a reference number. I want to link this to a service call number which matches the refernce number. ie: Service Call - 0000123456 Bitmap file - 0000123456 Link both into one report.
  14. zircom

    Matching Fields in Excel

    excelent help. FAQ very good. To add to my question: If i wanted to look for a number and match it, which is working now thank you, can it return a value associated with every occurence of that numer and return it to a single entry? eg: Sheet 1 1 2 3 A Job No Name...
  15. zircom

    Matching Fields in Excel

    Thanks. I am after comparing a column on sheet 1 and 2 which would be your column 'A' on sheet 1 to column 'A' on sheet 2 to see if any of the number match and then copy in the relavant name, irrelevant of whrere they appear in the column. Sheet1 A B 1 123 bill 2 345 bob 3 678...
  16. zircom

    Matching Fields in Excel

    I want to compare cells in differnet sheets to match the content and then copy a field into the other sheet if true. Sheet 1 Sheet 2 Job No Name Job No Name 123 123 456 789 If job number in sheet 1 matches...
  17. zircom

    Rolm VoiceMail

    Has anybody got knowledge or knows of a company that handles this product?
  18. zircom

    Date & Times

    great that works, stupid mistake, thanks again
  19. zircom

    Date & Times

    Hi, everything is set to Time or General. The time difference should be 4:26, but I still get 4:15. =IF(B3=K3,(HOUR(L3-C3))&":"&MINUTE(D3-C3),(networkdays(B3+1,K3,37669)-1)*9+(HOUR((0.72916667-C3)+(L3-0.354166666)))&":"&MINUTE((0.72916667-C3)+(L3-0.354166666))) I have...
  20. zircom

    Date & Times

    Hi, Sorry on closer reading it is not working correctly. Start Date St Time End Date End Time Calc 02/05/2003 10:45 02/05/2003 15:11 4:15 And this seems the case throughout. Any ideas

Part and Inventory Search

Back
Top