How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is...

I have a drop down list of branch names in one sheet. The source sheet (separate one) contains the values of this list and addresses and contact information,...

I know how to change colors in the palette, and I know how to copy a plalette from a workbook to use in another workbook. Instead of doing that, I would...

hi, am trying to keep help window from collapsing my excel window every time I open Help. (cannot compare problem to help file)

If a cell contains a set of numbers separated by a hyphen (eg, 1234-5678, can the contents be splitted up into 2 cells without the hyphen (ie, 1234 in 1 cell...

I have two groups of data A2:D1564 and F2:J1417. Each has a column (D & F) with 10 digit assignment numbers, most of which match from the 1st group to the...

I have Excel 2007 in English, but I sometimes receive data that comes from another applicationes, so dates are stored as text because they come in following...

Good evening, I completed my Microsoft Office 2003 MOUS exams. Unfortunately due to circumstances I no longer have the certificates. Is there any way of an...

Try these formulas 'If the lookupvalues is not found it will return a na() error =VLOOKUP("something",Sheet2!A:B,2,0) 'returns true if value is not found and...

hello! could anyone help me with my problem? the case is, I want to auto filter the non-blanks of a column (i.e. "A3") and save it before I close the...

Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any...

Hi all, how do separate alpha numeric value for example I have values like ABC123,AB234 starts with alpha but the length may be 2 or 3 or 4. just I want alpha...

Hello, I am editing a macro in VB under Excel 2002. I have created this function verticale = Application.WorksheetFunction.VLookup(Range(cella).Text,...

(This has been cross posted to the VBA group as well) Hello, I am just learning VBA and macros in Excel so forgive me if this is a simple mistake. I am...

Hi, I would like on the selection from a validation list to go to a particular cell on another sheet is this possible. Example validation list would contain...

In Col's C4:I4 have Mon thru Sun In C5:I5 have store ID's i.e., "NL" and "JP" which can move to different days from week to week. Have hours for each...

I am adding one cell and a cell from a worksheet within a file and the error code is 1E=05. Everything else works out but this one cell that is carrying...

Quick question if I may... I need to play two simultaneous sound files in Excel, and as I cannot have two userforms at the same time, I'm trying to have one...

Hi I would like to be able to insert live stock prices into a Word document if I mention the ticker symbol. For example, if I include "MSFT" in the document...

Hi I have several excel files which automatically save as a date. I would like to add a function to get data from a file defined in a cell. I have tried...