I use a sheet to store different modules with start and end time in a table (tab1). In the second sheet (tab2) I want to show all modules sorted in time...

e.g A B C D 1 Date (From) 01 Jan 2009 01 Feb 2009 01 Mar...

I'm using Excel 2007. I have created a table with customer numbers, names, status, and several other columns. I named this table including the header row...

I am having an issue with converting the month number to the month abbreviation. Below Should Return "Feb", but it is returning "Jan" 1.) ="Jobs Due In or...

I would like the word YES to appear in a drop down box but its 'value' to equal 100%.

Dear experts, I've a folder contains 30+ workbooks in a network. Each workbook is for one department to fill in different kind of requests. From column A to...

How do i calculate a whole list in one column (B1-b6) (mathematical function i.e. multiply, divide, summation) with another column (c1-c6) and have excel...

I have been trying to work out how to go about calculating multiple conditionals using the Wizard. In MS 2003 you can use the Add button.......in 2007 it...

I'm querying our Oracle data to Excel and can't seem to get a formula return as a new field. I need the proper way to write this sequence: IF(RM.RM_STD=...

My Range is A23:M:23. I want these to be a color if the contents of N23 is F. I have tried, =$N$23="F" as well as =$N$23=F without any luck. Any suggestions?

I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each cell. Some cells in C2:C15000 have the same text, or may have slightly different...

I have read the threads concerning the dates, however, I just can't seem to make it work. I have one column of dates that I want to change when the date is...

Hi, I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get the following output: If column A is 3000 then give me '1'; If column B is...

I need to know if there is a simple formula to add the current (static) date into the adjacent cell by entering a specific # into another cell. Example: by...

I'm trying to fill in Column A based on the info. listed in the first row for a section. For example, column A would list Store 1 until it hit Store 2 and...

I am calculating a Daily total as well as an accumulative. I need to subtract the previous days figure from the accumulative to get the current days total. ...

I am working in Excel 2007 in workbooks created in 97-2003. When I try to share the workbook, the program goes the motions then gives me a message the...

Hi, I am using rank to find the winners in order in a competition, for those that have not scored, how can I make the rank result blank. The lowest score...

I have a worksheet which currently is organized by UNITS/Divisions in our company. Following the manager's name I have four columns each for a different...

I have the following formula in column 4, row 4 of a multi row/column spreadsheet, where I am referencing a value from one worksheet and looking for the same...