I have a concatenate formula that includes a cell that contains a date. The date is set to a custom date format of YYYY-MM-DD. However, the formula is...

I have a table with names across the top and tasks down the side, i have set up a drop down list for each task under each name, in the drop down is level 1,...

Hello! I have a matrix with categories in the columns (from A to AG) and I use string reference (with INDIRECT) to access it in another sheet (same workbook...

Excel 2007 all patches loaded with Vista 64 business Can you clear the recently used file list under the office button in Excel 2007? thanks, Will

I know this isn't a function problem but I posted in the general Excel section and got no response so I thought I would try here where I get answers quickly....

I am trying to create a formula and evidentally I do not know what I am doing. I need HELP! I need to multiply any number over 2400 by .02 and get the sum...

Table - 1 :...

Is it possible to do a 'find' of a series of numbers (not within a range) eg. case numbers? I am wanting to look up about 150 individual cases yet don't want...

Everytime I open my aaaa.xls Excel displays a dialog box that states "C:/aaaa.xls contains macros." "Macros may contain viruses..." I have checked...

Hi, I need a formula that tells me when I have exceeded the optimum amount of production in a 24 hour period and 16.5 hour period along with an 8.5 period. ...

How do I write a function to subtract one row/column cell from one other row/column cell, comparative by location, such as the cell on the same row but the...

Is there a way to limit the number of currencies in the scroll down menu defining currencies I find frustrating to go through dozens of currencies, most of...

I have data like the table below. I need to sum the numbers in column C based on criteria in columns A and B. Something like a multiple criteria SUMIF...

Is there a formula which will search for the lowest number in a range and will put that value into another cell which can then be auto summed? Thanks, Shelli

I am having a problem constructing a golf scoring sheet that tracks team skins with team rotation every 6 holes and provides for carryovers across the 6 hole...

Is it possible to write a formula where A1- A100 (eg) is a different money value. Then I need to find 25% of that value and take it away from values in...

Hi I have 2 workbooks each with mutiple columns. WRKBk1: First Name (B) Surname(C) Email Address (E) Wrkbk2 (reference source): First Name (A) ...

Hi, IS THERE A WAY TO FIND ALL CORRESPONDING A'S FOR COLUMN "F" THAT HAVE THE SAME DATE IN COLUMN A. WHAT I WOULD LIKE FOR IT TO DO IS IN ANOTHER...

here goes i use excel 2007 and can calculate number of days between 2 dates using networkdays function. but my colleagues use older versions of excel and...

I cannot use any of the format functions in certain excel files that I get from other uses. How can I fix this?