I have worksheet that I have mulitple types of Billing Issues, lets say 20 types. I have been asked to shorten this list and come up with subtypes and add...

Hi I have a database where column A - D contain country, product, etc, column E - Q contain Jan - Dec and full year volume while column E contain Jan - Dec...

I want to put in text and split in half in a cell like values actions but with a line seperating them in two parts, I was able to use the borader but the...

I'm trying to combine three adjacent cells. The first cell has a name, the second cell has the, @, symbol and the third cell has the e-mail signature. How do...

How do I use an IF statement to look at a column of data and if the current value or text is repeated in that column to return a null or NA value?

Example: a number 1234 would sum individual dighits to a value of 10. I thought there would be a function in Excel that would do that but can't seem to find...

Good afternoon -- I've created a template for our company users, and have posted it to our corporate ftp site. Before releasing it, I'm testing to make sure...

I know it works but for some reason when Im entering in a formula using cells from another worksheet it will not let me click the cell to add to the formula

In the formula at the bottom, is there a way to "variabilize" the file name and path so that based on the value of cell the path might be...

Hi folks, I have a named range from Cell A2 to Cell A101 in a workbook. This is entered in the Define Name - Refers To box as: =...

Anyone know how to do this or a formula that will help me accomplish this? If information within Column C of Worksheet 1 is not within Column B of Worksheet...

Is there a AutoFit C API function in Excel which i can use to set a column to auto fit? THanks

Hello, I am looking to see if this is possible. I have my present formula below. What I would like to do is that if the date in E2 is blank then to default...

I'm in need of the following: a1=9 Formula: If a1 is greater than 8, I need b1 to show 8 only. If it is less than 8, I need it to show the amount that is...

Hi all, I want to type text in cells of one column in msexcell. and i want to use characters like enter, tab, bullets..... just like that we use in...

I am a little new to formulas in excel and I need some help. I have a large spreadsheet with about a hundred tabs. The first 30 or so tabs are individual...

I'm trying to add numerical data from 28 separate worksheets onto a "totals sheet" (the 29th workbook) and cannot figure out how to create the formula. What...

I am trying to automate a workbook to compile a weekly report. The workbook is made up of a control sheet which the end user will use to run the various...

I am trying to make labels where the text is different in Each label. I am having a very hard time getting the size of the cells correct. I need 3 columns &...