Search results for query: *

Hi Guys, please can someone enlighten me in what I presume, to the professional out there, requires a simple solution. I have two columns on an excel 2007 spreadsheet that I am trying to get the average on and exclude any blanks. my formula that works for one column is...

Please can anyone help. I have an Excel workbook containing a number of worksheets. My problem is that on one sheet(Bulk Pick) I have Rows containing headings(Location Names)and a column containing Product names. I wish to lookup the corresponding value contained at the matching intersection on...

I'm quite new to this VBA stuff and am obviously having difficulty understanding the different worksheet functions and where to place my code. I have a Summary Worksheet which (each time the workbook opens)I list in column A every worksheet name along with the sum of each corresponding...

Please can anyone enlighten me with the following problem I have. Firstly I have to say I have browsed this forum and the web with out success. I have a number of worksheets in my Excel workbook and each one is linked to my "Summary" worksheet. Each of them has a small amount of code contained...

Can any of you guys help with the following problem.I receive a spreadsheet in which a number of cells contains lists of numbers seperated by comma's. At present(due to lack of blank cells) I copy the data from their current cells and place it into a different column so that I can manipulate it...

Can any of you guys help with the following problem. I receive a spreadsheet in which a number of cells contains lists of numbers seperated by comma's. At present(due to lack of blank cells) I copy the data from their current cells and place it into a different column so that I can manipulate...

We use MS Outlook and exchange and I wish to provide a current user of outlook with the ability to view another users mailbox whilst that user is on holiday. I know I have had this facility before but cannot remember how to do this. I know that I ammended some settings within exchange and then...

I have an excle spreadsheet that I need to construct a vlookup on and started searching the web for ways to do this and so far have only been able to get to the point of retrieving cell information from an workbook/worksheet that is open using the INDIRECT function. Obviously any help would be...

Can anyone please point me in the right direction as I am told that it is possible to set up a shared calender on our 2000 server which is running sbs version of exchange as we want to be able to allow certain network users to log dates of notes/meetings and out of office information where...