Hi With minutes in cell H59: number of days = INT(H59/(24*60)) number of remaining hours = INT(MOD(H59,24*60)/60) number of remaining minutes =...

Hi if you have stored your social security number in column A (as number) use a helper column (lets say B): - enter the following in...

I found it! I took the info from this tutorial, then once I had the macro for automatic numbering, I put a button in the cell and assigned the macro to it....

I have a worksheet that I have separated in 4 pages. Borders are set on various cells. Some of the borders show on one page and not the other.

I'm positive I asked this recently, but cannot find the post or the sheet I used this on. I have a pretty standard lookup situation, but LOOKUP is returning...

Hi all. I wanted to share this information with you, since it contains recent updates for Microsoft Excel 2003 (7); plus complete information about Microsoft...

Trying to count the number of blank cells between two points. The problem is the end point can vary. Cell 1 020w Cell 2 030w Cell 3 Cell 4 Cell 5 Cell...

I am using an xl spreadsheet as a front end to link data to other spreadsheets in the same folder. I have no problem creating the links and getting the...

I think it would be easier for you to use conditional formatting. Select the cell (or range) you want to format. Go to FormatConditional Formatting Select...

I have a question maybe you can help aladin. I am trying to copy a formula down a column and the formula copies fine but when I hit the enter key the cells...

I have a table with column-headings and row-headings. I would like to convert this table into a list with three columns. The the list will extract the...

I have 21,000 records in a database. Some of those records have a single code associated with them, some have multiple codes. I need to figure out the number...

I use the function below in order to remove "trailing dots" from tasknumbers. For instance, it changes "1.1.1." into...

Can I copy a formula and paste it across a worksheet over cells, some of which I want to change and replace with this formula and some I want to leave as...

Help! I'm using excel and the dget function to lookup product pricing data. The problem is that the pricing data is now 75 colums by 1,700 rows and I expect...

Hi Group, I have 2 Excel files. One has a macro that reads through values in the sheet and updates a formatted Template with these values. The...

I have a table that I would like to transpose from horizontal to verticle. It is structured like a database with the fields in columns and the records in...

Other than sorting, does anyone know how to delete all blank rows from a report in excel. The reason we need this is b/c we have a software aplication that...

I downloaded a self-extracting file that is a text file with carat delimiters. I want to convert to an Excel 97 file without the delimiters.

How can I get the group symbols to print on my reports? The group symbols and marks show where one can collapse/expand sets of rows/columns to...