I would like to find a formula that allows me to sum or average numbers from a column of data over a number of days to be entered in a separate cell. The...

Hello, I am trying to use conditional formating to select multiple rows, but skipping some rows and than coloring the body... Example: If cell A1 is...

Hi! I have some customers that I have given a Excel file that each it opens ask too update against a excel file I have put on the web. Now I want to password...

I have made a excel file with drop down list that have several products too choose from in the list, what I would like too have is a drop down list that...

i have for example this formula in cell (=text(datevalue,"dddd"))--so when i enter date it will give the day the question that when i click on this cell it...

Hello all: EXCEL has the function to input calculation results. Say A2=2, B2=3. If we want to input C2 with A2+B2, then we just, with cursor on C2, need to...

I am trying to come up with a way to automatically update current cell values when I make a new entry for my spread sheet. For example, I have a...

Is there any way to take only a portion of an amount in a cell and then multiply it by a number? Let's say that I have $1000 in a cell, but only $50 of it...

can anyone help?

Hi, good morning everybody I need your help! I have a list and I like to use it like this. Colum A = Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of...

All - Thanks in advance for the help. I have a long list of text values and I want to count the number of cells that contain error values rather than text....

Hi, I have a table of contact list in which person's employer name is entered. What i want is to use that employer name (from input column) and arrange...

Hi, I have an xl having "XLODBC.XLA'!SQL.REQUEST". and i am fetching values from oracle database. After that i want to create an ouput file with values...

Greetings....... How can i schedule to run an xls file on specific time if it has macros to enable. Thanks in Advance Zubair

Can anyone elaborate me how I can make multiple dependent drop down. I want to create a drop down list that depends upon two values. And second, I have a...

I want to create a drop down list which depends upon two or three previous drop down list. What I want exactly is to to list down first the type of...

My first question is I want to lookup multiple values in the worksheet. In my specific problem, I want to lookup three and four cells to find their matched...

Hi! Is there a way (even a long way) to apply conditional formatting based on order, say: I want to paint bold blue the 5 highest values in a row? Thanks.

I have a data by heading in a file as a master data file. I do have form 7 file with 10 worksheet. each worksheet represent single form. In master data file...