I am attempting to create a cross reference between 2 spreadsheets. I am currently using the "VLOOKUP" function to obtain my results. The problem that I have...

I have a column of data with blank cells inbetween some of the information. I would like to list this column of data on a separate worksheet, with the blank...

How would I assign a row to appear at the top of every page? For instance, I have data in row 1 and I would like it to appear at the top of every page as a...

Hello Excellers, This is my problem: B2 = 10:00 D1 = 11:00 Formula in D2 =B2 & " - " & D1

Hi Im trying to use an IF function based on two different conditions. Any help greatly...

Just wondering, i am trying to do a stock sheet for my bar to purchase product. I have a number of colums. the 2 most important colums are 1. Cases required...

I am building a time sheet that requires shift differential. If an employee works the majority of there shift after 3:00 PM they get .05 differential.

I'm having a hard time getting a function to calculate number of minutes between two times that takes into account business hours and business days. Has anyone...

Is it possible to reference a worksheet name in a cell of the worksheet? When you do this in a header it reads &, but I can't work out how to put it into a...

I have data in the following format: Name Date Amount Johnson 6/1/06 $100 Johnson 6/6/06 $300 Johnson ...

How can I check for #Value! in a cell? ie If(c4 = #Value!, 0, 1). Alternatively, is there a way of looking for the maximum value in a column based upon a...

I a table that shows interest compounding for a savings account. A variable amount of money will be taken out each month and that should be taken into...

Excel may not be the best program for working with trihybrid crosses (3 traits), tetrahybrid crosses (4 traits), and so on, but I have been able to create a...

I'm trying to run a macro with the following formula in it: Range("M2").Select Selection.FormulaArray =...

I'm in the process of making a very large macro to format a report and identify errors. To do this, I have some gigantic array formulas, and they seem to be...

If I divide two negative numeric cells and put the result into a percentage cell, it will positive, even if the change is negative. For example: A ...

I'm sorry if it's hard to understand what I'm asking about, but here it goes... I have a spreadsheet organized by reference numbers, and each reference number...

I have 7 rows in the same column of type percentage. I'd like to turn the text of the highest valued cell red. How exactly is that done with contional...

If cell A1 is 0, I'd like the text of A1 and B3 thru B10 to be gray. I know how to conditional format for the current cell but how can I also format other...

This has more to do with formatting a text string, but how do i format a column that already has data in it using "=TEXT(A1,"@")"? This is the only way i...