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 Rhinorhino 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. Kurupt55

    formula problems

    Just had another look and if you are trying to get the percentage mark for each student the formula will be =SUM(B7:AN8)/SUM(B$2:AN$2) In cell AO7 Impossible is Nothing
  2. Kurupt55

    formula problems

    Hi Sandy I have had a look at your spreadsheet and it looks like a count function would do nicely =COUNT(B4:B41)/COUNTA($A7:$A41) This is assuming that you want to automatically calculate th percentages. If you put that formula into cell B48 on your mathematics sheet this will calculate the...
  3. Kurupt55

    Use V or HLOOKUP to return multiple values

    If there is only one occurence of your unique ID in your manytable then there should be no issue with returning values from columns 2 3 and 4. If you want them individually you would have to write 3 different formulas: =VLOOKUP(B3,manytable,2,FALSE) =VLOOKUP(B3,manytable,3,FALSE)...
  4. Kurupt55

    Please help with a macro in Microsoft Word 2007

    I created a word document with 6 pages each with a number on it and it worked fine. saved 6 new documents with each page. Impossible is Nothing
  5. Kurupt55

    I need help on creating an Excel Formula

    Sorry formula is wrong, Should be: =IF(A2="",C1,A2) You will have to manually enter the first site code into cell C1 Impossible is Nothing
  6. Kurupt55

    I need help on creating an Excel Formula

    Actually After thinking about it, If you dont like using VBA then you could use this formula in Column C =if(A2="",A1,C1) then just copy down to the end of your data and then copy column C into Column A using paste special -> Values Impossible is Nothing
  7. Kurupt55

    I need help on creating an Excel Formula

    If I am following this correctly then your data looks like this: 123456 Jane B John A George A Georgia B 654321 Peter X Percy Y Sally S If this is the case and all the people below 123456 are in that site and all the people under 654321 are in...
  8. Kurupt55

    Web query automation

    Thanks skip Im not really up to scratch with VBA and this is a bit of a hybrid that i was trying to adapt to suit me hence the bits that were not being used. Not sure why there was a select statement in there but it was working for me so i left it. Ok as I was writing this I realised what the...
  9. Kurupt55

    Web query automation

    I am having trouble with the following code Sub getitems() Dim WSD As Worksheet Dim WSW As Worksheet Dim QT As QueryTable Sheets("Sheet1").Select For m = 1 To Range("C1").Value Select Case m Case Else mystr = m End Select...
  10. Kurupt55

    vlookup for searching?

    I managed to do it with a combination of functions dont have time to post a full solution but start with =IF(ISERROR(FIND($A$1,$B1,1)),0,$B1) Assuming your search text is in cell A1 and your data is in B1, then fill this to the bottom of your data This will filter out entries that do not...
  11. Kurupt55

    Access Vs Excel

    What im struggling with in Access (and yes im not very well versed in the program) is I want to be able to assign A staff member to a Job for say 50% of the week and 20% of next week, but rather than doing it individually I want to have a table where I can see all staff and all projects and get...
  12. Kurupt55

    Access Vs Excel

    Sorry about the title didnt know how to describe what i wanted. So here is my issue I have been asked to design a capacity planning tool and have been throwing around ideas on how to go about it. I have made one before in Excel which worked fine until it came time to add more fields and...
  13. Kurupt55

    Excel 2007 - Assistance with Conditional Formatting

    I am with skip on this one. the solution i posted works for me on my spreadsheets but with multiple users editing it a simple piece of VBA code will do the same thing but more reliable Impossible is Nothing
  14. Kurupt55

    Every other row in excel

    If you select each INDIVIDUAL row while holding Ctrl untill you have selected all your data, then right click on a row number and select insert. This will put a blank cell in between each set of data. As for the border issue, rather than using copy & paste i would use format painter. Format the...
  15. Kurupt55

    EXCEL drop down list.. 2003

    Data validation only returns the result of the cell. I would make a table with the values that you want in the first column 25% OF TOTAL 50% OF TOTAL 75% OF TOTAL 100% OF TOTAL Then in the next column put the formulas that you want it to return =A1*.25 =A1*.5 =A1*.75 =A1 Name your first column...
  16. Kurupt55

    Retrieve only non-blank cells from a lookup

    This is a messy solution but it works insert a column in Column A moving your data to Column B In cell A1 use this formula =IF(ISBLANK(B1),"",1) In B2 Use this formula =IF(ISBLANK(B2),"",MAX(A$1:A1)+1) Copy B2 down to the bottom of your data range In column C Put Numbers 1 to 100 (or as many...
  17. Kurupt55

    convert text to hyperlink

    Right Click on the cell, there should be an option saying Hyperlink. A pop up will appear and will give you the option of pointing the hyperlink to the folder/file/whatever. Click OK Voila Alternatively hit ctrl + k or insert --> Hyperlink Impossible is Nothing
  18. Kurupt55

    Parse One field to Two fields based on UpperCase

    Assuming that your names are always LastnameFirstname, would there be first names that would have 2 uppercase letters in it? If not then you could use the max formula =MAX($B1:$AA1) this would give you the starting point of the first name IF there are no caps in the first name. but you would run...
  19. Kurupt55

    CountIf problem based on a character ?

    I understand What you are getting at now and have had a play with the formula. =COUNTIF(YourRange,"<8") will count all cells that have a value less than 8 but will not include text strings. =COUNTIF(YourRange,"8-15") will count all cells that have the text string 8-15 hence this will work in...
  20. Kurupt55

    CountIf problem based on a character ?

    Try COUNTIF(Sheet2!a1:a21,"<=15")-K1 COUNTIF(Sheet2!a1:a21,"<=30")-K1-L1 This will do what you want (obviously change the range to suit your situation) Impossible is Nothing

Part and Inventory Search

Back
Top