How can I create a formula that will look at the name in a column and create a salutation?

I have government reports that need to show a zero with a line through it so they are VERY distinguishable from the letter "O". I cannot find a format that...

olá, estou trabalhando no desenvolvimento de um projeto BI e preciso de uma ajuda. tenho que criar um gráfico baseado em uma tablea dinâmica, mas...

I am using a barcode scanner to read in barcode numbers into excel. But everytime after I scan a barcode, excel moves to the cell in the next row. What I want...

I have a pre-made form, and I it has a check box with the title "trade for service" next to it. I need to change that title, and can not get to the cell to...

Thanks for the help. I am using Office 2003. I would like to be able to hyperlink from a cell in Excel to a specific place in a Word doc. When I use the...

I have list of dollar amounts given to me and a general ledger sum which some of those in the list must equal. How can I determine which of these amounts will...

Can the value of a cell be displayed even if the cell is on too narrow a row? I am designing sheet music staff on a spreadsheet in which the staff...

How can I sum a range of amounts, each of which has a respective date associated with it, based on whether or not that date is less than or equal to a cutoff...

Hi, I am using Excel 2000 and have a cell that contains the format of time (hh:mm) and would like to see the calculation, to put into another cell, that would...

Hi all- I'm not sure if I'm using the correct terminology but if you have a cell link that says =A1 and you copy and scroll that down the cells below it will...

Does anyone know if it possible (and how ofcourse) to make a pop-up message window in excel that operates on the (Macro-)button. It has to contain a choice...

Example:Excel worksheet-Column A has list of Cat or Dog (say 15 items)-Column C has their age in days old (10,3,4,etc) I need (2) Averages- Average age of Cats...

The following will not solve (or start to solve?): H4=I4+J4+K4 I4=60.73 J4=constant/(constant*M4) L4=(I4+constant)/2 M4=function(L4) I get this error on...

I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B.

There must be a way to format all sheets in a workbook with the same footer format (i.e. file name, tab and date) at once rather than tab by tab. Can anyone...

Hello, What is the VBA code to hide a wookbook while running a VBA macro? -- Regards, Jeff ---------------- This post is a suggestion for Microsoft, and...

Need help with an If statement which refers to different sheets. In Cell B2 is where I want the value returned If Sheet1 B4 not equal to "pens", put "Not...

I have a spreadsheet that has about 3500 rows. I have one column that has a formula subtracting certain times. On some of the results I get a negative result...