I am looking for a three digit Julian date formula for my spreadsheet. I have found formula's that display the julian date with the two and or four digit...

I have a list of items in column A and I need to create a drop down list in column B that excludes any duplicate data. Does anyone have a macro that can do...

I'm trying to create a formula that will give me the Average number of Days Activities early (-) or late(+) based upon the due date. Column B represents the...

I would like to tike a formula that IF for example a cell value is greater than 5 but less than 10.01, the cell value is multiplied by 5 if true, or a "-" is...

I am using Excel 2003. I have a spreadsheet with one column and hundreds of rows of text data (exported from an open ended survey question). I want to be...

Hi, i need a macro that can filter range A8:G200 based on criteria in G column. Criteria is date, and i need to filter based on today's date. If today is...

Hi, can this macro can be modified to copy from range A6:G100 rows that has in G column today's date?(18.09.2009) Sub COPY() MyWorkbook = "" & Format(Date,...

Dear All, Could anyone help me to slove this problem. I have an excel worksheet data contain 4 column for meteorological daily data the first column is year,...

Hi, Accurate Engineering Works Contact Address: Near Canal Bridge, Dugri Road, Ludhiana - 141002 Punjab Phone : +91-161-2492554/2490553 Fax :...

I have a rectangle I made from the drawing tool bar and then I assigned a macro to it... can I change the text of the rectangle based on the string stored in...

I want to format 16 Digit CC#'s as 0000-0000-0000-0000. When I choose Custom and enter it as I did above or using all # symbols (####-####-####-####), it...

I frequently wish to enter a function as one of the arguments to a function. You can click on the function icon in the formula bar to enter the top level to...

I have read the previous queries about Excel opening when file is double clicked but not the workbook, along with the recommendation to "uncheck 'ignore...

Im trying to determine a way that I can see all of the cells that reference another cell. Similar to F2, in that it shows all of the cell which are...

Everytime I close out of excel it does not give me the option to save my work. Please help.

I am trying to copy one cell to another with a if function. And if there is nothing in the cell, I would like the other cell to be blank. I have tried...

When I open a specific workbook in Excel, it automatically opens two identical versions of the workbook. Closing one closes both of them. Making and saving...

I didn't find an answer to this when quickly looking over past discussions. What I want to do is clear a cell value out after eight hours or so. I may have...

I have Exel 2007. Would anyone know how to size an embedded word doc to show all pages of information? I created an Excel spreadsheet where one of the tabs...

I am not sure what type of formula I should be using for the following, but I can't use an array entered formula or the column or row functions and was hoping...