Is there a function that can extract a sheet reference name from an =Sheetname!cell so that another cell can display the name as text?

The formula below will produce a value that is greater than 6 in my spreadsheet. However, I want to add another condition to this formula to minus .5 ofF...

Hi Everyone, I am trying to do a simply lookup table, but its been years since i have done it and can't remember. i want the excel to give me a dropdown of...

In cell A1, I have an INT(RAND) formula to produce a random whole number. In cell B1, I want another random whole number to be produced, but I don't want it...

Hi, Is it possible to look up not only the contents of a cell, but also the cell color using a vlookup? Thanks,

Can sumproduct be used to return cell content? If so, does anybody have a sample that will requirte two conditions to be met. Thanks,

Can they be combined?

Hi, I have a list of part numbers that show cost prices by month for 2008. I need to pull the last cost for 2008. Problem is, if there was no cost change...

Can vlookup or any other function bring over the cell formatting?

Column A contains names of students who had taken a test. A B C Tested All Students Richard Richard ...

I don't understand why we use cell referencing at all. Can anybody tell me what is the different between these references $A1, A$1, and $A$1 or exactly what...

I am having trouble using SQL.request with Excel 2003. Excel does not recognise the function & I can not find an ODBC addin for 2003 (which is what was used...

I have added conditional formatting to a spreadsheet which greatly increased its size. (It went from 16kb to 1.31mb) Is this nmormal, and is there a way around...

How do I exclude blank cells in calculation an average in excel. For examples columns include the following Blank 4 1 3 I want to include the...

I'd like to have Sheet2 cell B3 the active cell when closing workbook. I know the code goes in Workbook_BeforeClose(Cancel as Boolean). I just don't know how...

How do you folks write this function if cell A1=B1, then cell D1=C1? I created a list for 50 states, but I don't want to use the drop down arrow to select...

I have tried using the following formula in linking two workbooks. How can I retrieve information (numbers) from two different cells in the source workbook?...

I want to create a time array. For example, cell A1 is the starting time of 6:00 AM, and cell B1 which contains the ending time of 2 PM. From 6 am to 2 pm...

I have this question in an early post "I want to create a time array. For example, cell A1 is the starting time of 6:00 AM, and cell B1 which contains the...

I have 2 columns that contain names and I want to compare the 2 and extract the names the exist in column 1 that do not appear in column 2....