Search results for query: *

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

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

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.

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

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

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.

Wonderful.....thank you macropod

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

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)".

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?

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

Thanks KenWright

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

Thank you both very much for helping me with this.

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

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

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