A welding helmet is a safety device worn for protection while one is welding; however, there are definitely many other uses for a welding helmet. A welding...

Hi, I'd like to know how to get a value from a cell into another behind a text string by using a formula. For example, A B 1 20 Result...

=IF((A2-A1)1,"Missed " & TEXT(A1+1,"mm/dd/yy") & IF((A2-A1)2," - " & TEXT(A2-1,"mm/dd/yy"),""),"") I tried that, but it didn't work...:( ...If you have...

I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now having problems even opening files. If I click on a cell it pauses for ages and...

i have data in column A of words i want to know if it is already with column B, the problem is column A does not have the exact word and i used Vlookup and...

I would like to know if there is a way that Excel can pull the current Month numeric value off of the computer system. I am working with figures that need to...

How to format a column as three-letter week, eg. Tuesday-TUE thanks

I'm entering training dates in Excel. The recertification date is one year from the original date. I want the recert. due date to enter itself when I input...

Is there a way to automatically add/show rows that have data? I have a data entry sheet. Then I have a report. The report pulls data from the entry sheet. If...

I have 13 columns of data with 30000 rows. Most data is numeric some is 2 words at the most. The computer calculates cells very slowly and sometimes will not...

Is there a way to protect or unprotect all sheets at once without going into each sheet?

I have columns set up. Some have names and some have numbers. Can I use sumproduct to do the following? Column A is State Text Column B is Date ...

Hi Folks, hope you can help Somehow I have managed to change my excell and now have 2 "things" missing 1) Usually at the bottom of the page there is a box...

I have have col d 3-80 that i would like to sum the total of records that i have that are not 0. first i did =count(d3:d80) which gave me the count but now i...

I tried to change the folder that excell uses to another folder and now when i open excell it cycles thru all my excell files and opens them but withe...

The new trial verison of excel 2003 is not working and it won't let me register it online. Help

Alan Wrote: To find the last row of data try =LOOKUP(2,1/(Data!A$1:A$200000),ROW(Data!A:A)) use this with ...

hi, I've got a 'quotation system' and i need to work out a way, so when i press i button (I've got the button) it recognises the last entry put in 'Customer...

Ok, well, i have been set the task of making an invoice system that even a noob could use. The invoice system is for a chemist. At the moment i have my main...

My EXCEL 2007 has switched to Numeric column notation and I can't switch find how to switch it back to Alphameric. As it sits, cell designations must be...