
When I freeze rows I want it to scroll 1 at a time, not 3 at a tim
...

3 
12/4/2008 9:39:01 PM 

How do I vlookup
I've got 2 worksheet with about 25 pieces of data. I need to be able to
identify when one of the pieces of data are not the same in each worksheet. I
created concatonates in the first column of each (columns in each associated
with account #, billing # and name). That's my join info. I want to be able
to id those where the phone # on each are not the same. Would I do a vlookup?
How do I ...

5 
12/4/2008 8:34:48 PM 

Autofilter with Sum product?
I am trying to use sum product I believe for the following formula.....
=(SUM(M3:M468)/SUM(F3:F468))/1440
I am trying to use autofilter to give me the above answer for just the
fields shown after filtering. Any ideas????...

3 
12/4/2008 7:22:34 PM 

Is it possible to display feet and inches in one cell ?
Microsoft Excell 2007  I am trying to convert a number to feet and inches.
As far as I can tell it will only show feet or inches but not both such as
1ft 5in....

5 
12/4/2008 6:14:57 PM 

Lookup Value in Table
Excel 2007
I have data that looks like the following
A B C
Row 1 INTC MSFT IBM
Row 2 $1500 $2400 $1850
I need to write a formula that finds the maximum value in row 2, and
returns the corresponding value in row 1. The MAX() function will
return $2400, but I can't figure out how to get my formula to return
"MSFT" which is what I really need.
Any help will be greatly appreciate...

9 
12/4/2008 6:14:01 PM 

IF Function .....
Very sorry  I have posted this in another groupd and have realised
this is in fact the correct place to ask.
I am currently using the IF function to display a score value based
on
age. I am currently using 2 cells with 2 seperate equations for boys
(with age in C5):
=IF($C$5=11,10.6,IF($C$5=12,12.8,IF($C$5=13,15,IF($C$5=14,17.2,IF($C
$5=15,19.3,IF($C$5=16,20.1,IF($C$5=17,20.9,IF($C$5...

4 
12/4/2008 5:56:33 PM 

Flagging an outdated cell
Along the same lines as another thread I read earlier, I am trying to set up
cells that will turn red or have a validation message pop up if the date in
the cell is over 60 days old from today's date. I want it set up so when I
open the spreadsheet, if the date in, let's say, cell K8 is 7/11/2008, that
the cell should be red, or I have a message pop up when select the cell
saying that th...

6 
12/4/2008 5:39:59 PM 

Percentage increase of one cell to another in Excel?
I am trying to find the percentage difference from one cell to another. Cell
C1 is $89 and cell D1 is $99. What is the formula to find the percentage
increase?

Holly N...

5 
12/4/2008 5:18:55 PM 

training tracker
I am tracking training for my unit using an Excel sheet put out by the
military (must use).
The columns are each seperate training class and the rows are the individuals.
Each class has a Shelf life (must be completed with in a certain date. That
date<MOB=mobilization> is solid and does not change, all the other columns go
off that cell)
I have placed a conditional format on each co...

4 
12/4/2008 5:14:38 PM 

Find matching values
I regularly have to compare two spreadsheets of account names to find the
matching values. Each spreadsheet has account names in one columns, but then
other columns will have different info, which I have to merge together if
there are matches.
I usually line up the columns and then color one set red and them put them
into the same worksheet and sort by name and scan visually for matches...

3 
12/4/2008 4:57:01 PM 

Transpose with Match ?
Hi,
Was wondering if possible to use the Transpose function with another
function. On Sheet 1, I have names in C3:C20, with data in each row of the
names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of
those names from Sheet 1 can be entered, then have the data from Sheet 1 on
that row that matches the name entered, be transposed to F3:F33 on Sheet 2.
So anytime the ...

5 
12/4/2008 4:36:02 PM 

Count multiple criteria
I'm trying to count how many times a combination of 2 criteria occur at the
same time across a range that sits in another worksheet in the same workbook
so I can summarise the amount of sales (not value) by month & year.
I've spent ages looking at the advice on this so far and tried various
suggestions involving the sumproduct, countif and IF functions. I can manage
the countif and s...

8 
12/4/2008 4:23:02 PM 

Referencing Icon Sets
Cells A1:A1000 contains a conditional formating Icon Set (red x, !, and check
mark)
I want Cells B1:B1000 to enter automatically insert text based on the Icon
in the A column.
Examples:
A1 contains a red x icon....i want B1 to put automatically put the text
warning.
Any suggestions? ...

4 
12/4/2008 3:07:01 PM 

VLOOKUP with a blank cell
I am trying to do a vlookup that looks for the value in the cells in column A
in my table. However, some of the cells in column A are blank. My lookup
table has a blank in the first column and a code value to be returned in the
4th column. When I try to do the lookup and it encounters a blank cell, I get
a #N/A result instead of the code.
Here is the formula I have now.
=VLOOKUP(A13,$F$...

6 
12/4/2008 2:43:03 PM 

vlookup and lookup
I'm using a simple 2 column table with either vlookup or lookup function and
some of the return values are the row above. I realize if it doesn't have an
exact match it will return the next largest value that is less so I used the
Round function to make sure there would be exact matches. What am I missing?

Ruthie...

13 
12/4/2008 2:17:05 PM 

Sum a NULL cell
Hi,
I've got a complete mind block on how to get this right!
I have 5 values in cells a1:a5  1, 2, NULL, 4, and 5. When I try and sum
all 5 cells I get #value! Can I sum all five cells (12) even if there is a
NULL in a cell please?
Thanks in advance,
AW...

7 
12/4/2008 2:04:56 PM 

Expand Selection in Auto filter
Hi,
My file has columns till DR. I have a spilt in the sheet at AP13.I am using
'Sort ascending' from the auto filter at CQ to sort the my file but my sort
selection is not expanding to entire columns. Column AAP are not getting
sorted ascending, and now i have data all jumbled up!
Thanks for your help.
...

8 
12/4/2008 2:00:20 PM 

Formula for empty cell
I am trying to put a validation into a cell that would refer to two other
cells. I want to make it so if I try to type text into B9 cell, I either have
to put an X in cell A10 or A13 first. I sure there's a way to do this, but I
can't figure it out. Any ideas?...

3 
12/4/2008 1:45:27 PM 

More Conditional Formatting
I posted a thread earlier:
"If i have a date in column A and have a formula that calculates 90 days
from that date to Column B and I want to add conditional formatting to Column
B that flags 120, 90, and 60 days from the column B date how would I go about
doing that?"
I receved the following (which works great):
=AND($B1>TODAY(),$B1<=TODAY()+60) < Flags Red
=AND($B1>TO...

2 
12/4/2008 1:26:01 PM 

Conditional Formatting
If i have a date in column A and have a formula that calculates 90 days from
that date to Column B and I want to add conditional formatting to Column B
that flags 120, 90, and 60 days from the column B date how would I go about
doing that?...

4 
12/4/2008 12:13:01 PM 

countifs on earlier version of excel
Hello,
I have been working on 2007 excel and used the below formula:
=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2)
I have just noticed upon saving that this will not work on earlier versions
of excel.
How do I need to change the formula please to make it compatible?
Thanks
Aaron
...

3 
12/4/2008 11:34:01 AM 

HLOOKUP Help
Sure this must be quite easy, but I'm trying to sum the number of training
days people have planned, booked or completed. A simplified version of the
sheet looks like this:
DAVE B B P P C C
FRED B C C
DAYS
for 1 2 1 2 3 1.5
course excel word ppoint access etc...

2 
12/4/2008 10:47:52 AM 

Normal distribution
Hi, good morning,
I have a list of values and intend to trace a graph of normal
distribution. How I can make using excel 2007?
Supose that this is the list:
column A
91,00
88,00
79,00
78,80
77,00
75,30
74,00
72,40
71,00
68,00
66,00
65,50
65,40
62,30
61,00
59,00
56,00
55,90
55,00
Thanks in advance!...

3 
12/4/2008 2:36:01 PM 

Flagging a cell
Hi,
I have two cells that I would like to use to flag one. I have a cell that
would show if an appraisal was done inside a home or outside. My Cell title
is "Apprsl I or E" and I have a list of properties that have an appraisal of
I or E. The column next to it is the appraisal date. I would like to flag the
appraisal date column cells if appraisal I is older than 6 months from
today...

4 
12/4/2008 10:04:01 PM 

vat formula
Can anyone tell me what formula I can use to calculate the cost before
vat based on the rate here in the UK before and after 1 December?
I know roughly what I want but don't know how to correctly put this
into a formula.
E.g.
I have the date in column J2 e.g. 30/11/2008
The total in column K2 for example £100
In column L2 I will have a formula something like this:
IF date in column J2 ...

3 
12/4/2008 10:40:08 AM 