i'm trying to copy a cell (both text and format) from one tab to another tab within the same document but keep getting just the text. is there a formula...

Trying to determine if the date and the time in a cell are the last day of the month, and if that's the case I want to perform a certain operation. Here's...

Using Excell 2003 program stops responding saves file then recovers the file but it is about half the original size. Under tools I would like to use the...

We have 5 projects going on, so I've created 5 different worksheets to track them. My boss would like an "admin" page. This should look at all the other...

Hello Everyone, I have a file that has 4 columns, one of which stores a number value. When this column has a value of 0 I want to remove the entire row. Can...

Hi, How can I get number in some cell to the number of some other cells reference? For example, if I have calculation in cell A1 giving some number XX and I...

I have a spreadsheet to list individual scores and show running averages for each competitor. Column B - competitor's name Column C - competitor's running...

I am trying to create a formula that when I input a date it will calculate the business day 45 days from the date entered.

I want to return an "X" in column Y if column 0 has the number 21 thru 27 all other values return nothing. column o is currently a caculated field with the...

Bill date qty Bill amt Pay.date Amt Bal. Days Disc@ Dis.Amt 18-Jul 18 800 19-Jul 900 -100 1 4 72 20-Jul 18 900 19-Jul 200 ...

I know the cursor automaticaly jumps to the last column in that row with data or formating - but I have tried to delete the rows inbetween the one I want it...

I am using nested IFs to determine the number of days between two events. If the two events occurred on the same day, how do I return a 1 instead of 0 and...

I have a spreadsheet of about 4000 rows that I have each row hyperlinked on. This hyperlink now has an error in it so I was wondering if there is a way to...

I am creating a number of spreadsheets that have multiple links with each other. One link I am trying to make is this: Condition: If column L has text...

Hello Everyone, How do I GOTO a specific row by row number?

I have a spreadsheet which assigns a class value to a competitor based on that person's average score. As I add new scores in a row for each person and...

I have multiple Criteria to count occurrences on. For example, Division Store_Number 011 01100002 011 01100006 011 01100012 011 ...

Hi, I am trying to check two cells for text and then display some other text in a destination cell using if(countif... It works quite well except for my...

Here is my If statement. I am getting an error message "too many arguments". Can you tell me what I'm...

I have a list of time values that I need to calculate the average, in excel. I am having issues coming up with a correct average.