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!

Recent content by ajduk1

  1. ajduk1

    Excel calculation / formula

    Thanks Glenn you are a star. All sorted and all looks great. Thanks again Andrew AJD
  2. ajduk1

    Excel calculation / formula

    Hi I have recently recieved a request from a colleague. I have a query pulling prices for products, eg. the product no is in column A, price in column B, conversion factor in column C. So I am pulling the product & Price via a query and need to add the conversion factor to column C. Data...
  3. ajduk1

    VLOOKUP Help

    Thanks Geoff I used your formula to an extent. I used : =vlookup($A1,CUST,column()*1,FALSE) this gave me all I needed when entered in B1 and dragged across. Thanks again Geoff AJD
  4. ajduk1

    VLOOKUP Help

    Hi I have a VLOOKUP that I need to use to enter info vertically =VLOOKUP($A1,cust,1,FALSE)(CUST IS A DEFINED NAME) If I fill down all is ok but I want to fill across keeping the absolute reference (A1) but allowing the lookup column to change from 1 to 2 to 3 etc. eg...
  5. ajduk1

    vlookup query

    Hi I have a query that returns the following: Prod w/h cost N1141D 90 0 N1141E 90 0 N1146A 01 0.95 N1146A 90 0.95 N1146B 90 0 N1146C 01 0.6 N1146C 90 0 N1146D 90 0 N1146D 01 0 N1146E 90 0 N1146E 01 0 N1147A 01 0.13 N1147A 90 0 N1147B 90 0 N1147C 01 0.12 N1147C 90 0 N1147D 90 0 N1147D 01 0...
  6. ajduk1

    Excel IF statement

    hi Gavona As stated in the initial question, the formula =IF($EJ14="?1","FERT" gives me a "FALSE" return. I went with the RIGHT function (GlennUK)and it works a treat. Thanks for all your help. AJD AJD
  7. ajduk1

    Excel IF statement

    Hi I have a spread sheet where I want to return a value if a field equals a specific value. in the statement below you see if($EJ14="K1" then return "FERT". The thing is I idealy want to return "FERT" if the $EJ14 field equals anything ending in 1, I have tried adding a wildcard so that it is...
  8. ajduk1

    [b]Cannot access bios or boot sequence on startup[/b]

    Usb devices Scanner Plotter Printer External Hard drive Graphics Tablet Keyboard Mouse I have unplugged all as suggested still the same. NB This was all done when the PC was playing up Got it started yesterday 3rd-4th try after giving up night before. This issue does not occure all the time...
  9. ajduk1

    [b]Cannot access bios or boot sequence on startup[/b]

    Sorry for the delay No I am using a wired logitech keyboard. Just got home I will have to try the other 2 tomorrow (sorry) Ajd AJD
  10. ajduk1

    [b]Cannot access bios or boot sequence on startup[/b]

    I realise the BIOS does not load the drivers, its just that this is the 1st PC I have had that has this issue Cannot access the bios because the keyboard is unusable until the bios has loaded. AJD AJD
  11. ajduk1

    [b]Cannot access bios or boot sequence on startup[/b]

    Hi I have a dell latitude which is all USB no PS2 The PC boots (sometimes) but although on the post I get F2 to setup, F12 boot sequence, as the keyboard and mouse are USB the drivers do not load until after the choice exits. There have been a couple of times recently when the PC partially boots...
  12. ajduk1

    sharing a printer Wirelessly

    Hi I have a desktop running XP and a laptop running Vista. The desktop is wired to a wireless router and the laptop connects wirelessly. I have a printer that has network capability. My question is how can I connect the printer so that both computers can see and print to it? Do I need to setup...
  13. ajduk1

    cannot ping PC's in domain

    Thanks Jimbo that done the trick. again many thanks AJD AJD
  14. ajduk1

    cannot ping PC's in domain

    Hi I have a number of machines in a domain , but I have 8 in particular that I cannot ping. I can ping other PC's in the domain from them, but cannot ping to them from any other PC. They are showing in AD as members of the domain infact everything seems fine i.e. they can access all domain...
  15. ajduk1

    <b>test</b>

    test AJD
See more

Part and Inventory Search

Back
Top