If I have a projected that needs to be escalated using start and completion dates by a certain percentage per year, how do I write the formula. For example...

If you have excel dates in the 1st row; dont forget to format the formula cells to date format -- Jacob (MVP - Excel) "Jacob Skaria" wrote: Hi Ben

Try these formulas 'If the lookupvalues is not found it will return a na() error =VLOOKUP("something",Sheet2!A:B,2,0) 'returns true if value is not found and...

What is an "add-in"? How does it work and how to make one? Thanks (the newbie is back)

I AM SO CLOSE! :-) Both ck13 & Ms-Exl-Learner have helped me down the path but I have 1 piece missing. Heres what I have now (Col A - done, Col B - not...

When saving file, Xcel generates .tmp file xls.~RFe17931.TMP in same folder with the .xls file. Can manually delete, but if I open the file and save again,...

We are using a scanner to input a barcode number into "Find What" box in find and replace in excel. Is there a way to make it stay highlighted for the next...

I have data imported from another file to Excel with negtive numbers show as 478.56- and so on. Is there a macro to covert all these numbers to a format...

Is it possible to write a Macro to make changes 2 another Macro. I have a complicated macro which may have 100 formulas, each day I add data which then...

Hi, i need to delete the rows where the comment in the column A contains some charaters...for example below are the comment in column A...and i need to...

Right-click anywhere in the pivot table and select "Pivot Table Options...". Make sure the box that says something like "Preserve Cell Formatting on Change"...

Hi folks, I have a simple workbook that was created from importing a CSV file. It just contains 4 columns of data. I would like to export the data as XML...

Hi, I dun really understand what is your end product but just give it a try and maybe you can make something out of it. I assume that you have information in...

When I exit excel only the workbook will close and I have to click the 'X' a second time to exit the application. and yes, I am using the application close...

--One approach is to use your formula in each sheet say in cell C1 and then in your summary sheet use a formula which will return the totol from all...

Try...

Afternoon Gurus!!! I have written the following code Rows("1:5").Select Selection.Insert Shift:=xlDown Range("A1").Select ...

I am currently using Excel 2003 and 2007 if necessary. I would like the ability to configure the excel sheet column sequencing when I hit the enter key or...

hi a add in is a special xl file usually with a .xla file extention that will load in the background when xl starts. it usually contains extra code or...

Marcella, Use the 'text to columns' function under in the data ribbon (2007) or the Data drop-down menu (2003). Use the 'fixed-width' selection and position...