Functions

Print Preview Different than What I see in the Excel File
When I created an Excel file and inputed text data, it shows that it is within the column width in the file, but when I do a Print Preview, it shows that the text is not fitting in that cell and is cutting out. What should I do to make sure that the way I type the text and it shows in the file, is the same way... 25 Mar 2010 12:40

reference cell from advanced filter
I'm sure this is slam dunk, but I can't figure it out :) On worksheet 1, I have executed an Advanced filter of 900 rows, to get down to one row. No problem. Now, on Worksheet 2, I want to reference an ID number from my filtered row. Obviously, simply doing a regular cell reference won't work (=Sheet1!G271),... 25 Mar 2010 23:12

Removing ''VALUES''
Hi Again (where would I be without the help from this board) I have a forumula in a cell as follows =IF(ISNA(VLOOKUP($A77,'Personal NFI 2010'!$1:$65536,14,FALSE)),"",VLOOKUP($A77,'Personal NFI 2010'!$1:$65536,14,FALSE)) working absolutely perfectly and if there is no number to find the cell stays blank... 25 Mar 2010 16:16

Functions on filtered data
Afternoon, I have an excel sheet of 10 cols and 200 rows on sheet 1. Sheet 2 has a table which searches through the list of data in sheet 1 to 1 - produce a list of unique items using the formula - 2 - find max/av/min of col F per item using formula - 3 - find max/av/min of col G per item using formula - 4... 25 Mar 2010 23:12

IF - more than seven arguments
Good morning I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this needs to be ongoing as the spreadsheet concerned will report ongoing data therefore there will be more than seven sets of criteria to be evaluated. Pleas... 25 Mar 2010 05:46

General Calculator
Hi all I have a SUM result in M8 (this is my sub total) I have a allocated cell Q8 to receive a final Total. Cells N8,O8,P8 will be allocated the functions /, x, - (Division, Multiplication, subtraction) I would like Q8 to display the result of M8 being either /,x, or - If neither of the 3 function are ac... 25 Mar 2010 06:53

How can I count values in multiple non-consecutive cells?
I'm trying to figure out what formula to use when I want to count how many times a value is found in a specific set of cells. ... 25 Mar 2010 05:46

Entering Formula - Cannot select cell as it is hidden by formula
I'm using Excel 2007 When I'm entering a formula into a cell, the text of this formula if longer than the cell covers the cell to the right and then I cannot click on this cell to automatically put that reference in the formula. The same happens when you are in a table, but the formula is centered on the cell... 25 Mar 2010 04:39

Missing Record in Table Lookup
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 'Mortgage_Pay_Table'. Excel automatically named the table EXCLUDING the header as 'Table4'. This table has 37 rows excluding the header numbers from 100... 25 Mar 2010 01:02

How can I allow users to sort a protected table using dropdowns?
I'm trying to create a table where users can't edit the content of the cells but can edit the ordering of the table- what's the best way to achieve this? ... 6 Apr 2010 09:42