I have a calculation that gives me a percentage. This percentage needs to then be divided by .50. However, if the percentage in the field is greater than...

Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The...

If there a way to delete all the macros if the workbook is saved with another name? Thanks, Danny

I was reading about deleting blank rows but they aren't really addressing the problem that I am having. I pull info from an outside program and insert it into...

how do i delete the "page 1" watermark from my spreadsheets. all i want is a plane spreadsheet without it. thanks

I have a spreadsheet with various values in three columns. Each column is a different month of the yr. The values in some of the cells are used to calculate...

When page break preview is on the spread sheet data input crawls. enter data move to next cell have to wait up to 10 seconds for data to move to next cell....

Any VBA or vanilla excel formula to make the above check if both A1 and B1 are validated using the same drop-down list? -- - Zilla (Remove XSPAM)

I have searched all over this forum. I have gone to several different websites suggested by other questions/answers. The one most like my scenario is on ...

Hi I know how to write out the nested if functions but was wondering can the wizard handle it. It seems that there are only 3 boxes in the wizard,...

For some reason, when I use this formula, all I get is the first item every time. Is there any chance there is an error somewhere? "RagDyer" wrote: If...

I have a spreadsheet that tells me how many hours are worked at our production centers and I would like to find out if there is a way that I can use the data...

Hi Experts, Is there a formula/macro that I can apply to the results of a Vlookup function(=VLOOKUP($A$6:$A$119,Swe_Lookup,2,FALSE)) to replace the "Value...

Hi, I need to create a hyperlink from a sheet to another, that must check if a text appears in a collumn of the 2nd sheet, and if it does it must cretate the...

Hi, I have a list of data comprising movement events and their starting and ending locations that looks like this (its much longer):...

I have a worksheet that may have a "1" in it from Columns K thru BB. There will only be 4 "1"s. What I am looking for is a formula to put find those values...

Hi All I am using Excel 2003, I want to put a formula on my spreadsheet in O9 that will sum from O13 through to the last value in the column which changes...

I have a large .CSV spreadsheet that shows all of sales history for the past 12 months. I would like to separate that data into bottom-tabbed worksheets. I...

I want create a formula that if the Min column (C3, F3, I3, and so on...) is greater than 0, then A1 will combine the XX1, XX2, XX3 and so on... can anyone...

Cells E16 through P16 contain different numbers. I would like to be able to select all cells in this range and apply a 3% increase. Is there a function that...