Search results for query: *

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

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