|
|
SUMPRODUCT Issue by
Adam Lauzon
I am trying to set up a summary page from data collected
over the past few months. The 2 colums of data that I am
trying to reference are a date colum in a...
|
|
2 |
100 |
|
|
Excel Table Help by
Adam Miller
I have created a table that displays the weekdays of the month, who has the
highest commission and how much they earnt in the form:
Date | Seller| Commission...
|
|
2 |
143 |
|
|
Conditional Formatting by
Adam Ronalds
How can I use the formula function in conditional formatting in order to
indicate if a formula in the cell has been altered?
( 1 2)
|
|
10 |
140 |
|
|
|
|
3 |
85 |
|
|
Excel Number Sorting by
Adam Rothschild
I have imported some data into excel as text because if I
do so as general, excel chops off some zero's placed after
decimal points. (for example 151.0 151.00)...
|
|
4 |
390 |
|
|
OFFSET Function by
Adam Smith
Dear Folks,
Using Excel 97, primarily,
Recently discovered the usefulness of the OFFSET function.
For example, I keep track of the Consumer Price Index,...
|
|
2 |
390 |
|
|
Excel date intervals look up by
adam smith
Hi Im trying to lookup a value based on date intervals for academic years, using birthday to find the year.
So for example if I enter a birthday of 22/09/1997...
|
|
1 |
71 |
|
|
Excel 2007 Nested formulas by
Adam Stegeman
In cell AD4 I want a number to appear. I want it to count how many times the letter "C" appears in column E IF column F has the word "July" in the...
|
|
2 |
128 |
|
|
|
|
3 |
81 |
|
|
Help with this formula. by
adam.carson
I am working with a bunch of qualitative data, such as Poor, Fair, Good, and
Exc. I am trying to give a value to each response and total up each person's...
|
|
1 |
76 |
|
|
|
March 13th, 2008 02:26 AM
by Max
|
1 |
42 |
|
|
|
March 13th, 2008 06:56 AM
by Max
|
7 |
64 |
|
|
time in minutes and seconds and .00 by
adam11m
I don't know how to format a cell so when I enter a number it is not in a
date format. I want the number to be displayed as minutes, seconds, and 2...
|
|
2 |
95 |
|
|
Combining multiple lists into one ! by
Adam194
I would greatly appreciate anybodies help with this:
I have 6 lists (defined as Nicki, Cathy, Dawn, Alison, PatJoy and
MikePauline). I downloaded an example...
|
June 19th, 2006 02:06 PM
by Adam194
|
0 |
104 |
|
|
Cell calculate only once by
adamb
How can I have a cell calculate only once?
Example:
Equation in cell D7 "=A1+B1"
So if I create this equation in cell D7 yesterday and A1 and B1 both...
|
|
1 |
67 |
|
|
|
|
2 |
89 |
|
|
VLookup a Vlookup by
adamb2000
Hi,
I have created a VLOOKUP function which looks up a value in a different
Workbook.
Bases on this returned value I would like to create a VLOOKUP which...
|
|
4 |
134 |
|
|
|
|
0 |
108 |
|
|
|
November 20th, 2007 11:07 PM
by Max
|
9 |
62 |
|
|
|
|
1 |
325 |