Does anyone have any suggestions on how many way to represent the blank space in Excel? "" is a blank space. Does anyone have any suggestions? Thanks in...

I want to print a report from a macro. I recorded a macro and got this: With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" ...

I have the following Data A B C D 1 X1 10 X2 2 2 X1 15 X3 5 3 X2 5 4 X2 6 5 X3 11 6 X3 ...

I have got a sheet from the internet,when I open it ,I did not found any sheet tabs. it is very interesting for me to design some sheet in this way. so...

Excel 2007, I select 1 cell and excel selects 2,3 or 4 cells below the chosen cell. I've scoured the help menu's and can't find anything related to stop this...

i am creating a time sheet to track hours worked in a week and the pay due for those hours worked. each day has 4 cells to enter in-out-in-out times. the...

I want to set up a loan, lets say for 100,000. The payments are interest only, payable and compounded monthly. the principal of the loan is due on 60...

I have a list of addresses, where I want to sort by road column, but ignore the numbers in front of the road name. When I try to sort it sorts by the house...

does anyone know how I can put a cap of 400 on this formula? =IF(H9="","",-MAX(0,MIN(H9,100)*0.05)+-MAX(0,(H9-100)*0.02)) Thanks so much and have... --...

I have created a defined name for a cell b5 containing a phone # and named it "Phone". When I want to access it by typing " =Phone" , I get a value error. Of...

I'm trying to write a sumproduct formula with mulitple conditions: C6=4/25/08 C44=Project121 I'm...

I need to take the average of colum A for the cells that have either a 1 or a 2 in the corresponding rows of column B. How do I do this?

I am trying to keep a running sum of customer order amounts for a given year to compare TY vs. LY using the following formula: =SUMPRODUCT(--('Wholesale...

When Excel opens, the focus is automatically placed in cell A1. Does anyone know the VBA code to force Excel NOT to place focus anywhere on the sheet? Please...

I have a couple of notebooks that do not show gridlines on new sheets. I know how to make them on. How do I set the default for this? J

I know there must be a reason that data/number not recognized, but changing formatting doesn't help - would have to retype numbers to get vlookup to...

sheet 1, has information in three colums, in which i wish to tranpose, to sheet 2. sheet 1 A B ...

How do I copy an e-mail message that I received into two or more seperate folders. Note: I posted this message a few days ago and a reply was received, but I...

I would like to keep a running total of $$ won and lost for a sports wagering project I am working on. As seen below I would like to input the risk amount in...

I'm not sure how to ask this, but here goes. A pivot table show only that data at each break in the sort. For example if I had a car database with...