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. walla07

    EXCEL - inserting fields depending on date creation

    Hi Diezz, The values update each time because you have a "live" expression in your formula, Now(). Every time you hit enter the whole sheet refreshes itself. One solution is to copy each date and paste as values (under the Edit, Paste special menu), in the same cell, each time you add a new...
  2. walla07

    Lookup part of a cell

    Ken, Thank you very much for those formulas, they work brilliantly.
  3. walla07

    Lookup part of a cell

    Hi, Thank you very much for everyone's time and effort in helping with this. I'm afraid I've not been able to try the solutions yet, but rest assured there are stars and thanks a-plenty as soon as I get chance. Thanks again.
  4. walla07

    Lookup part of a cell

    Hi, Is it possible to lookup and match on part of the data within a single cell, without running a text to columns to split the cell. For example, I have an order number A123456. A separate column shows the orders received by date and one cell could contain 'A123455, A123456, A123457...
  5. walla07

    Interactive Form Fields

    Hi Juniajon, One option would be to use the Tools - Protection - Protect Sheet option. Highlight the whole sheet and click into 'Format cells', go to the 'Protection' tab and make sure that the 'Locked' box is checked. This protects all the cells on the sheet. The next step is to highlight...
  6. walla07

    2 vlookups

    Hi nqueen, You could try a combination of the MATCH and AND functions. If you wanted to look up the data on sheet 1 to see if it was on sheet 2, =IF(AND(MATCH(A1,Sheet2!A:A,1),MATCH(E1,Sheet2!D:D,1)),"YES","NO"), then copy this formula into all the rows on Sheet 1. Hope this if of use.
  7. walla07

    Excel - Sum a range of data in the middle of a spreadsheet

    Wonderful.....thank you macropod
  8. walla07

    Excel - Sum a range of data in the middle of a spreadsheet

    Hi, I have a number of sites for column headings (across to column BE) and a number of accounts in the rows (down to row 102). What I would like to do is to sum a range of the accounts for a selection of the site headings at the top, if the site heading matches a certain criteria; initially I...
  9. walla07

    Cell splitting

    Hi Lewis, If you highlight the whole range then use the 'Data' - 'Text to columns' wizard. Set the option to Delimited and check 'Other' in the next step and use - to separate the field. Another option, if all the employee numbers are the same length, would be to use the formula "=right(A1,5)".
  10. walla07

    Odd Excel Problem

    Very daft solution, but does it let you use your mouse on the vertical scroll bar in the workbook you want to link to? If it does, does it work if you click down a couple of times on the scroll bar before linking to the cell?
  11. walla07

    Excel 2000: Want to copy value from one row to blank rows

    Highlight the range you want to fill in (City), press F5 and select the Special box, choose Blanks and press OK. Then type =A10 in the first selected cell (A11) and press Ctrl and Enter, this should copy all the info you need into the blank cells. Then copy the whole column and paste special...
  12. walla07

    Excel function to return if 2 out of 3 criteria met

    Thanks KenWright
  13. walla07

    Excel function to return if 2 out of 3 criteria met

    Hi, Please could someone help me with the wording for an Excel function that would return a value if 2 out of 3 criteria is met for a given value. A specific example is three criteria, i.e. 10, 12 and 15 and a value of 14. The test would be if 14 is greater than 2 out of 3 of the criteria. It...
  14. walla07

    Disable F1 key in Office (especially Excel) (LOW PRIORITY)

    Thank you both very much for helping me with this.
  15. walla07

    Disable F1 key in Office (especially Excel) (LOW PRIORITY)

    A purely cosmetic question... Is there a way of disabling the F1 key in Excel, so that it doesn't call up the Help application, without turning off the functions of the other F keys. I regularly use F2, F4, etc., but occasionally miss F2 and end up hitting F1 and then have to wait whilst the...
  16. walla07

    Excel chart that crosses the x axis

    Hi, Is it possible to present a column chart in Excel where one of the values crosses the X axis, instead of starting from 0? For example, I have a count of a number of items in the office, pens, pencils, etc. and there and 10 pens. Ordinarily Excel would show a column of 10 starting at 0 and...
  17. walla07

    Unhide more than one worksheet at a time

    Is it possible to unhide more than one worksheet at a time? I've tried the obvious stuff like using Shift or Ctrl, but this doesn't work. Thanks

Part and Inventory Search

Back
Top