I have been researching and trying to figure out how to get a spreadsheet do some counting for me. I am on active duty with my National Guard unit on a...

I need a formula for excel to autonumber a sheet as it is saved as. This is for a customer file which is used as an order input suite. Does anyone know how to...

I am trying to 'make one' a number of columns... Essentially I have several thousand rows of data that I need to clean up... What I would like to accomplish is...

How do I use SUMPRODUCT if one of the criteria arrays is the same as the totals array. I want to total all cells in column L that have a 1 in column D, as...

I have 10 years worth of monthly data and need to determine the best (or worst) three consecutive months for benchmarking purposes. How do I write a formula...

Dear expert, Have posted a similar message before, but look like no one replied. Lat me try the last time as I found the previous post was not clear...

I need to add hours if 3 critera match. In the below, if there is a 90 in the G column AND a 10 in the J Column, AND a 100 in the D column, then add the H...

I want to add 100 calendar days to a date in a cell and when that date falls on a weekend or holiday the formula will return the next workday vs. returning a...

A number of people can access and update a spreadsheet that I designed for them. The sheet contains a column with lookup formulas. I need to be able to...

I have following problem: I use drop down list for entering data in some cells. In other cell I use formula (VLOOKUP) and lookup_value is value from the list,...

Hi, I need to use data in my source workbook in another, destination, workbook - however, I don't want the data to automatically update in the...

Hello ppls, I need an Error Handler which looks like this: Sub Macro1() On Error Goto AAA Workbooks.Open Filename:="C:\dir\dir\book2.xls" Exit Sub

Trying to execute a recorded macro from an IF function. I have tried CALL statement but doesn't seem to work. eg. IF (A1=1,call macro1(),2) Is this the way...

Hi, i am trying to find the numbers 6,4,8 from sheet1 to popup on b1,b2,b3 and b4 on sheet3 everrytime when i enter the names Code: --------------------

How can I select a range and list them in a different sheet by highest to lowest and each label it is associated with? For example: Metal $235 Wood ...

Help! I'm using the XIRR function for a series of cashflows. It appears that instead of calculating IRR back to the earliest cash flow date, it is...

Hi, Does anyone know how to do this? Example: If F5 contains data, return the content of cell a1 to a cell on another worksheet. If statements don't work...

Thanks for looking at this post. I noticed that if I set up a defined name for a range on one worksheet (say 'Sheet 1'!A1:D50) and call it JanData03, whenever...

I am trying to add the values in col. n if their corresponding values in col A are not blank. The following formula is not working, please...

I'll try this again as I accidentally hit the enter key after typing the subject. In a spreadsheet I have all of my staff listed by their abbreviated names...