Hello all, Is there a way to have a formula and text within the same cell? This is what I want to do: Date: =TODAY()

Is there a way to use the COUNTIF function with 2 conditions? Right now I have the function: *COUNTIF(F11:F502,"Amisys")* which works fine. I want...

I am trying to use functions to create a list of data on one sheet by replacing the data in a single cell many times on another sheet. Can this be done using...

Hello, at first place I would like to say I don´t have very good skill in excel, so if my question is stupid, please be kind on me ;) I need to create some...

I'm working on a spreadsheet for sports and want to rank certain stats from 1 to 20, to include a 'T' if there is a tie betwen scores. Example: 1, T 2, T 2, 4...

Duke Carey wrote: You ought to receive input from some of the sharper advisors here, but for the meantime I'd suggest you use a custom function like the one...

I need to have it look at one cell at a time, but link 20 cells in the formula. It is supposed to count the number cells that contain an X. I can't use the...

Can this be modified to check for a text value instead of a numerical (n6=1)? =IF(J31,0,IF(N6=1,G6,D6)) I'm getting the results I want, but I would prefer to...

We are trying to take only specific information from one worksheet to print it on another worksheet in the same workbook, if it matches the specified...

I just got set up with Office 2007. I was creating some spreadsheets and found that I can't just copy formulas over. I fill in a sum formula, and then drag...

hey!! i'm working now with dynamic range for single column and charts. i've a chart with number on the y axis and dates on the x axis and i would like to...

Hey!! I’ve been having some troubles with Excel 2003 (SP2) chart. I’ve to do a chart which the x axis is date type data and in which the same date has...

how could I import a text file with comma separated values into excel? Thanks in advance

I would need help on the following question: How can i, create a macro to associate with a buton on a excel sheet, so that every time i push it it sum one...

I'm having trouble applying the right formula to my spreadsheet. What I'm trying to do is compare two columns and determine which numbers in column A appear...

Hello, I was hoping you guys could help me with the following. The data I am working with is as follows: Date Type 1/1/06 ...

The db was created when 10 number digit was not necessary. I need now to either merge the area code with the number or precede all numbers with the same area...

When typing a formula in a cell, the cell covers the content of the cell above which causes you to navigate around the cell to get to the cell above. You...

Hi I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as...

I need a Function to copy a series of Rows (each four Rows Together) dependent on a criteria on the same sheet and paste it in another Sheet. EXAMPLE: 111 ...