This is my (disgustingly beginner's) function: =IF(AND('Worksheet2'!A5:A12="", 'Worksheet2'!B5:B12=""), "Both Columns Null", IF(AND('Worksheet2'!A5:A12"",...

i'm working on a shipping log that i do now by hand and would like to automate if possible. every load equals 1,000 and alot of the loads are split loads. ...

Example Col A Col B Count the number of a's in Col B only when an x is in Col A x a x a Result should be...

I opened the xlt file in my start folder and added a defined name. I must have done something else because now whenever my Excel 2003 opens it gives me the...

I am wanting to generate random numbers from 1 to 20 in cells A1 to A20, but have no duplicates. How can I do this?

In version 2007, I am trying to adjust the status bar to a larger size so that I do not have to squint to see the sum totals. For some reason, the 2007 excel...

Hi, I have to calculate the following Employee job in must be 9:00 am, but employee arrived 8.53 am. Which formula must I use to calculate the 7 min ?

I want to set the default for all comments in any Excel spreadsheets I create so that they always show rather than hide. Right now, each time I create a...

At my work when new hires are going through training, all of the work they complete needs to be entered in an Excel spreadsheet so we can track whether their...

I have a protected worksheet in Excel. After I protected the sheet I selected a range of cells that users could edit. When the sheet is protected the tab...

dear all , i post this query second time, someone angry with me that plz do not post the query multiple but still my problem was not solve if u dont mind...

When I click on a single cell anywhere in the worksheet, Excel selects as well the adjacent cell to the right on the same row. This doesn't happen when I'm...

I am trying to insert a word object into an excel for, but word is not available in the list of create new tab. I know I can copy or cut and past special to...

I have to compare student names on spreadsheets to determine if a university can be paid. I have a master list of all the students that are eligible for...

Hi, I could not find the solution to my problem in the questions asked so here we go: I have two lists, color and type: Color: Red, Blue, Green Type: A, B, C

total average result...

guys, i have a student record and for that i calculate total,avg and result but the problem is rank ....what i need is i would like to give the rank to only...

I have conditional formatting on a set of values to highlight high/low values using a 2-colour scale. Is there a way I can get another set of cells to mirror...

Have a workbook with 2 worksheets. Main worksheet contains all projects, opened, cancelled and closed. Contains columns A-Q. Column Q is entitled...

I'm getting error 13 "type mismatch" when I run the below code. I've tested it on a small new excel sheet and it work fine. There are no other macros in my...