Sorry I have to post a new thread. I have not been able to do it the way I've been told. I dont know VBA or programming. I make macro by recording steps. I...

I have a workbook with a worksheet displaying all the jobs I have in different categories. I would like to display on the my worksheet "Nikkis Critical...

I use two monitors at work and I function 99% of the time in Excel. It would be wonderful if I could maximize one workbook on the first monitor and maximize...

Sorry that i can't be more explicit. but here is the problem. i have downloaded a report from another software into Excel. the other software's report is...

I need to graph two separate named ranges as a continuous data series. Example: Series 1; "PastMonthActuals" = Sheet2("A1:A3") Series 2; "Projections" =...

hi- i need to return a value based on 2 conditions... i have a list of 500+ names, they all have a unique identifier (employee id) so i need to get different...

I have a spreadsheet that runs throughout the day. There is a time function built in using =now() and Text(A1,"H:MM"). Is there a way to use the time to...

how can i ctreate a list in one cell such as drop down arrow

Hi I have a cell for example that displays 03/07 as a text field for month and year. I want it converted to date field to display as = mar-07 or march 2007....

I have the following formula to check for a...

spreadsheet a and linking to b. spreadsheet a's date comes in as 3/16/2014 on spreadsheet b even though it says 3/15/2010 on spreadsheet a. i have same...

Is there a way to get the SUM function to increase the range if a row is added right above the previous SUM range. FOr example to go from SUM(C3, C22) to SUM...

I transfered files from Scottrade to Excel to forward to someone ... I removed the files from My Documents to the Recycle Bin, but the file names remain in...

I have a user who created a workspace and included a file that he now wants to remove from the workspace. Is there a way to remove one file from a...

And if there is a difference, what is it? They both appear to copy the data from the cell above the selected cell.

Is there anyway to input a date in a cell when data first appears in another cell? For instance, if I entered data in cell A1, is there a way that B1 will...

I have feedback from 26 people in different files with the exact same format and columns names, etc. Is there a way for me to merge these all into one file...

I would like to record and display the date in a column when a particular event happens. For example, I'd like to display the date that each row in Column A...

I am looking for a formula (excel 2003) that gives me the following answer. (in box 14) If line 10 is more than line 13 enter the answer J31 ...

A link to a collection of videos and tutorials on MS excel:Add-in. Tutorials:http://www.dataminingtools.net/browsetutorials.php? tag=msexcel Videos:...