Functions

How do I reference the cell which returned a lookup value?
Imagine that I've got a column of 100 numbers. First, I want to find the maximum value (MAX function). Let's say that turns out to be in the 80th row. Now I want to find the minimum value from the 80th through the last (100th) row. Note that the range of my use of the MIN function depends on where the original M... 1 Apr 2010 20:15

Counting Filtered Results Using Autofilter
I frequently use Autofilter to count the number of instances in a column of data. Usually, when I apply the autofilter to the column heading and execute a search, the number of results appears in a bar at the lower left hand corner of the Excel window, similar to "127 of 658 items". Periodically, this changes ... 1 Apr 2010 20:15

Calculating new date by entering number of additional workdays
Would love some assistance with the following: If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell (B1), resulting in a new date -- skipping weekends -- in a third cell (C1). Looking for the formula for C1. If it helps, here's an example: * Start date... 1 Apr 2010 19:09

Conditional Formatting: comparing cell values
Using MS 2007, I have a column that has 40 sets of three rows; the rows are for three seperate years for 40 different schools that are included in the chart. The cells I am workign with show the performance indicator - a number - for each of the three years for the school in that set. I need to compare t... 1 Apr 2010 16:54

Need to separate and rearrange names
How do you take Last,First and change it to First Last? Ex: Joe,John needs to be rewritten to John Doe. Using Excel 2003 and having the formula be in a different cell than the text it is converting so that the original text remains unchanged. ... 1 Apr 2010 19:09

See if cell value appears within a value range given by another cell.
Did you copy down to A10000 as Per suggested? Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 12:39:21 -0700 (PDT), Pierre <cowguy(a)aol.com> wrote: Per, can it be adjusted to find a "Yes", or "No", if the value is found (or not found) within all the cells in the entire column, not just the range in A1? Let... 1 Apr 2010 16:54

How do I compare two columns contents for differences
I have used this formula in the past and have been able to then sort on column C and it would but the number (matches) at the top followed by the #N/As. Is there a way to eliminate the "sort on" criteria or do this in another way? thank you, Marsha M "ScottO" wrote: One way ... If the 194 cells ar... 1 Apr 2010 16:54

Figuring Dates quit working!
I have used a spreadsheet for years (not created by me) that figures dates for leases. I enter the starting date at the top, then in a column the number of months for each step of the lease. The formula would then figure out starting and ending date for each period. Example: Starting Date 4/1/2010 3 4/... 1 Apr 2010 18:01

Absoute Cell Ref Changes When Inserting New Row in Referenced
THANKS SO MUCH!! "Gord Dibben" wrote: I think you have a typo or two in your description but maybe this will help. In B5 of Sheet1 enter =INDIRECT("Sheet2!C4") Will always refer to Sheet1!C4 Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 10:45:02 -0700, jj <jj(a)discussions.microsof... 1 Apr 2010 19:09

Help for sharing a worksheet from a excel sheet
we have an excel sheet with multiple workbooks in it i.e.tabs.Now we want to create a new excel sheet which has only 1 workbook from the actual excel sheet.but the new tab or workbook should be updated whenever data is updated in actual excel sheet. I tried excel services but due to lots of unsupported items i... 1 Apr 2010 15:47