While day trading I'm required to keep a time log when each trade has been executed.

How can I add a months worth of dates using the Excel Operations Employee Timesheet. I dont understand the formulas

I want a count of specific words in a range. For instance, how many "unix, sap,windows,etc" are there in this range? So I can have a number. That way I don't...

When I update my master worksheet, I want to save time by updating several tabs at the same time. I am using the following formula/function:...

How can one print the contents of the 1st column to each subsequent pages? If this require macros.... um, I don't know how to do that yet :-( cheers day

I have two Excel 2007 files that I need to join to form one spreedsheet of data. I have the unique identifier column in both files. There will be some records...

Hi I am trying to write a formula that will enter the date in field A2 if there is text in B2 but the date must be the date when B2 was typed into and...

I am using an * for identification purposes, is there a way to highlight the cell each time an * is entered? Thank you for your assistance.

I have a line of activex checkmark control boxes. How do I total the number of boxes that are checked?

I have 2 files i need to compare one is a file from our customers and one is a file from our office but in their files are missing information which are in our...

I have two separate excel worksheets i need to find out if there is a way to compare between the two to see the ones that are missing from one another

Does anyone know how to lock a particular cell to prevent the changing or erasing of a formula without having to password protect the...

Okay, here is my situation...I have Excel spreadsheets with file names, but they have the file extension at the end (all being '.pdf'). I need to delete the...

Okay...I have a list of vendors on a spreadsheet (color coded to engineers in case you are wondering why the screenshots are so wild and colorful), and when I...

I need help with a SUMIF formula. I am trying to do a SUMIF with the range being a column of dates. My criteria needs to be = than a date I specify, such as...

I have a range of dates that cover many years. I need to be able to count the dates that are within the last 365 days from the todays date

Its kind of hard to put into words what i need, but its basically a time balance sheet for payroll. I have a cell with a static value, say 49 hours. I want...

Is it possible to click on a formula cell whose formula references are on a different worksheet and have those formula reference cells colour highlighted in...

I am using ISERROR in conditional fromulaes but I am unable to get them to work on Functions such as Correl, Thankyou for your help

The Vlookup searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table Is is...