problem with index formula
The following fomula is contained in cell C16 and returns the correct
The following formula is contained in cell L18 and uses the result in
C16 as a lookup value in the first "match":
My promlem is that when I try to match on cell C16 my index formula
returns an error. However, when I change the index formula to
reference another cell (let's say cell D16) and I type in the value
shown in cell C16, the index formula works fine. I think my problem
has ...How do I display a formula calculation in plot area of a chart?
I want to add a text box in the chart that returns the value from a formula
that was entered on the data page. The formula value is not related to any
You need to build your text expression in a cell, then insert that
expression to the chart.
First, to build your text expression:
1. Select your cell
2. Enter = first to let Excel =know you are adding a formula
3. You can now enter text within quotes and cell values .. here's an
=" Yesterdays average temperature was " & sheet1!$a$3
Note that the & is used to add ...What is the cell data reference for 5th row and 7th column called
Can someone help me with this question? I need to get the answer for my
homework. Thanks for your help.
I'm guessing, but might it be G5?
Please keep all correspondence within the NewsGroup, so all may benefit !
"Shyemail@example.com" <Shyfirstname.lastname@example.org@discussions.microsoft.com> wrote in
> Can someone help me with this question? I nee...IF FORMULAS #2
Looking for help...... In column A1:A16, I have names. In B1:B16 I will
assign random numbers to those names from 1-16. In another part of the sheet
I have 16 columns lets say D:S, (D) being column 1 and (S) being column 16.
when I assign a number in column B, I want the name to the left to appear
above the appropiate column. EX, If B1 is 16 then the name in A1 will appear
above column S.
I am using Excel 2007 Windows Vista. I find this site to be the place for
answers,everyone is great. Thanks in advance.
Fill to S1.
"JOHN...tab between sheets
Any way to select a different sheet without using the mouse
Message posted from http://www.ExcelForum.com
> Any way to select a different sheet without using the mouse?
> Message posted from http://www.ExcelForum.com/
Go to Help, type in keyboard shortcuts
This will give you tons of information
"laneman >" <<email@example.com> wrote in message
: Any way to select a different sheet witho...how do i see the numbers of pages at the bottom of my work sheet?
i used to see the page numbers at the bottom of the screen when i worked on a
multi-page document, so i could easily move from page to page. now i have to
go to edit- then go to page- which is very inconvenient. what happened
> i used to see the page numbers at the bottom of the screen when i
> worked on a multi-page document, so i could easily move from page to
> page. now i have to go to edit- then go to page- which is very
> inconvenient. what happened
View / Status Bar.
**MS Picture It! MVP**
...Cell Contains Data.
How can I tell a cell that IF a cell contains data (numbers, text, whatever)
do x or y. How can I identify data?? I don't want to tell the function to
look for a specific number or text, just data, just something in the cell...
"GEM" <GEM@discussions.microsoft.com> wrote in message
> How can I tell a cell that IF a cell contains data (numbers, text,
> do x or y. How can I identify data?? I don't want to tell the function ...Active cell highlight
I would like to know if there was a way to have an active cell always in
yellow or any color.
Example: If the active cell is moved around, the active cell will be always
Thank you in advance
you may want to try Chip Pearson's Rowliner:
> I would like to know if there was a way to have an active cell always in
> yellow or any color.
> Example: If the active cell is moved around, the active cell will be always
> in yellow.
> Thank you in advance
Dave Pet...Need to separate multiple numbers in one cell
I have multiple number in one cell and i need to somehow put each number into one separate cell for each number:
I have :
row1 2 5 8 10
column B column C column D column E
row1 2 5 8 10
How do I do it on Excel 2007?
EggHeadCafe - Software Developer Portal of Choice
Map Stored Procedure Output To Class Properties
Use Data > Text to columns and specify the delimiter as space
...Need Formula to Average Monthly Increase
I have a spreadsheet where there are columns for each month of the year
Each cell contains a number of loan submissions that graduall
increases per month as we gain more business from each mortgage vendor
I need a formula that can look at multiple cells in a row (i.e
Jan-Dec) per vendor and then give me a result that shows the averag
monthly percentage increase factor in submissions...
MONTH Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A SUBS 1 5 18 29 30 40 57 85 150 275
..I will be using this data fo forecasting future submissions ...copy value in cell above to cell below for a whole column
I have a spreadsheet that was saved from a report. this report only lists
the employee name once. There is a way to copy the value of the cell above
to the cell below. I can get as far as highlighting the blank cells with the
Go To function, then I can not remember the steps to tell excel to copy the
data into the blank cells.
Can anyone help?
Ctrl+D will copydown the value of the top cell to the highlighted cells below.
> I have a spreadsheet that was saved from a report. this report only lists
> the employee name once. There is a way to copy th...How can I remove the previous lock cells and keep the new ones.
Could you please help me?... I locked and protected the cells A1:H20 in the
sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect
these cells and locked and protected the cells A21:H40 instead. However, for
some reason the cells A1:H20 are still lock and protect.
How can I remove the previous lock cells (A1:H20) and keep the new cells
In EXCEL 2007 take the following actions to unlock cells A1 to H20:-
1. Home / Cells group / Format / Unprotect Sheet / enter the password to
Unprotect Sheet / OK / highlight cells A1 t...Existing formula
I'm working with a spreadsheet that was built by someone else and cam
across a formula in some of the cells that I'm puzzled by. The formul
begins with "=", but the next character is "+", then a reference t
another worksheet and cell. The "+" is what I'm wondering about,
haven't seen it used in this context before, can someone help me ou
here? Some examples of what I'm looking at are:
Message posted from http://www.ExcelForum.com
It's an unnecessary character that is there because the person ...Going Back in History formula?
How can I express a formula that would back 300 rows and look at every
other row for the 3 cells with random single digits from 0 to 9 and
calculate, the how many rows back since the oldest 0-9 digit occurred
in cell 1 answer, cell 2 answer and 3 answer, then calculate which 0-9
digit has not occurred in cell 1, cell 2 and cell 3 the longest and
displays how many row back since the last occurrence.
So that would be 4 separate formulas
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.Exc...How do I enter a time formula into a worksheet that determines if.
How do I, set about entering a formula within a worksheet that determines if
the Time is greater or less that the time in a certian cell;
eg =if(now()>K17,"then display this","") K17 holding the Value 08:30 AM
formated to time
=IF(MOD(NOW(),1)>K17,"then display this","")
>How do I, set about entering a formula within a
worksheet that determines if
>the Time is greater or less that the time in a certian
>eg =if(now()>K17,"then display this","") ...formulas changing when emailed
At work, I have created a spreadsheet that has links to workbooks in a
user drive..called the "U: drive."
When I transfer this excel project to others via email, I make sure
that the other workbooks also have the same name in their U: drive as
However, whenever I email it... I have to change many of the formulas
at their computers bc the references in my formulas change to a really
I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't
work for me bc I have "+" "=" elsewhere in my formulas....Adding data from multiple cell and linking to a new worksheet
I have data in a sheet with names and amounts due. Like
There is a second sheet named summary. I want the totals of each person to
appear in the summary sheet. These should be linked cells and any change in
data in sheet 1 should be updtaed automatically
Create a PivotTable
"Rashmi" <Rashmi@discussions.microsoft.com> wrote in message
>I have data in a sheet wi...Move cells down to match cells
A B C D E
1 000801025-8 009601025-3 2007 000801025-8 2007
2 000801026-9 009601026-4 2004 000801026-9 2004
3 000801028-1 009601028-6 2006 000801028-1 2006
4 000801036-8 009601036-3 2008 000801036-8 2008
5 000801044-5 009601044-0 2007 000801044-5 2007
6 000801044-5 009601055-0 2004 000801055-5 2004
7 000801055-5 009601064-8 2001 000801064-3 2001
8 000801055-5 009601091-2 2006 000801091-7 2006
9 000801064-3 009601095-6 2002 000801095-1 2002
10 000801091-7 009601097-8 1998 000801097-3 1998
11 000801091-7...using data from another cell
I would like to type a name in one cell(1) then check in list (different
column) if the same name is there, and if it is there get a value of another
cell locate in the same row where. Can some one help me?
Create your second list and use VLOOKUP as follows:
Name is typed in: A1
List of names and values in: C1:D10
"leo" <firstname.lastname@example.org> wrote in message
> I would like to type a name in one cell(1) then check in list (different
> column) if the same name is there, and if it is t...How to exclude cells from a datasource?
I have an XY chart in excel97 that uses a range of cells
for the data source.
Every now and then I would like to exclude a XYnode from
the chart. Without having to reselt the datasource.
Is there a value one can enter in the cell that exludes it
from the graph (compare: putting text in a cell excludes
it from the SUM() function).
point X Y
a 1 1
b 2 2
c 3 3
Gives a graph with two lines connecting the three points
point X Y
a 1 1
b ? ?
c 3 3
Should give a graph with one line connecting point a and c.
Point b is left out.
Or is the...What must I do to get gridlines printed for both filled and empty cells?
What must I do to get gridlines printed for both filled and empty cells?
I'm a teacher, and I'm trying to replicate and print, in Excel, an
attendance book format, with a series of tiny squares next to each student's
name. The printed form of this would allow me to register if a student were
present or absent on a particular day.
Hubert Earl, vendor of fine Jamaican art, coffee, etc. on eBay:
Fine Jablum Blue Mountain Coffee sales page:
http://stores.ebay.com/Jamaican-Coffee-Art-and-More-Store_Jab...Copying formatting of entire sheet
I made an Excel 2007 workbook which includes my monthly business income,
parts bought, a logbook for car mileage dividing into personal and work and
finally a financial end of year total constantly updated by the income or
parts bought over the financial year.
What I would like to know, please, is how to copy the entire logbook (12
sheets, 1 per month then 1 for end of financial year totals and 1 for car
miles) FORMATTING so that I can have it all ready for the next financial
year. I live in Australia and our financial year ends Jun 30 and starts the
new one July 1. What I would like t...Macros on Protected Sheets #2
Now I have tried Alan's Solution to be able to run my Macros in Protected
sheets but as I am not VB literate, I think I have made a Syntax mistake.
Sheet("Critical Path").Unprotect ("My Password")
' Newaction Macro
' Macro recorded 17/11/2004 by Clifford
Selection.AutoFilter Field:=1, Criteria1:="="
Sheet("Critical Path").Protect ("My Password")
I receive a message "Compile error"
"Sub or function not defined"
Can you tell me what's wrong ?
...Excel 2003 - VBA
I'm drawing a blank and need some help.
I have a table with row 3 containing sheet names (currently pointing at 106
In rows 4-250 I want to put formulas that will look for something (located
in Column B) in each of the sheets named in row 3. The first cell in the
target sheet contains the last row with valid data.
Cell "D3" = P02-05
Cell "B5" = 123456789IBM
In cell "D5" I want to generate a formula that will look in sheet P02-05,
search for the contents of "B5" throughout the sheet and return the Value in
colum...Excel Cell Formatting #3
How do I centeer a picture in an Excel cell?
you can't as such objects 'float' above the cells in Excel
"Tom Coffey" <Tom Coffey@discussions.microsoft.com> schrieb im
> How do I centeer a picture in an Excel cell?