|
|
Formula for Minimum/Maximum by
LaDonna Brooks
Is there a formula for the following situation?
1A - 10,000 1B - AL
2A - 15,000 2b - GA
3A - 35,000 3b - SC
You have a min/max of 12,000/25,000 AL....
|
|
2 |
162 |
|
|
2 Dependent lists based on the same list by
EZ[_2_]
How can I have a 2nd dependent list based on the same main list. I have my
main
'category' list, then I created my 1st dependent list 'Products' both are...
|
June 24th, 2009 03:48 AM
by EZ[_2_]
|
2 |
135 |
|
|
Finding Circular References by
Philip J Smith
Hi.
I have a workbook that displays "Circular references" in the lower left
corner.
I have checked each worksheet but the message does not change to include...
|
|
2 |
129 |
|
|
Formula (Excel 2003) by
Newfie809
Hi there,
I am looking for help with a spreadsheet formula,
I have 54 Worksheets and on Line C6 of each worksheet is the Description and
on
E6 of each...
|
|
6 |
146 |
|
|
Date comparisons within AND() functions by
Sambonator
I'm trying to compare dates within an =AND() function but having trouble.
I can get =IF() to work but not =AND().
E.g. Cell A1 = 6/15/2009
I can do...
|
|
1 |
150 |
|
|
Using If function with text values by
IF function with Text
I'm trying to use an if function with the logical test being, for example,
=IF(A10=apples, , )
Is there anyway to utilize the IF funciton using a name or...
|
|
5 |
141 |
|
|
Paste Special Glitch by
Lady Success
When more than 2 instances of Excel are open, the Paste Special views the
data as an object when you try to copy the data. There are times when I need
2...
|
|
1 |
116 |
|
|
OFFSET and MATCH functions for cells by
Neecy
I have a spreadsheet and reference file in which I am attempting to import
the values of a cell from the reference file into the cell of the spreadsheet...
|
|
4 |
107 |
|
|
Countif issue by
Stuck
Here's what I have:
=COUNTIF(OFFSET($P$9,0,0,(COUNTA($A:$A))-2,1),$P3)
column A is a number
cell P9 is a formula that produces text "G"
cell P3 contains the...
|
June 23rd, 2009 10:29 PM
by Stuck
|
3 |
145 |
|
|
|
|
4 |
130 |
|
|
|
June 23rd, 2009 10:08 PM
by JRD
|
2 |
129 |
|
|
Auto Arrange by
Kanmi
How can I arrange names aphabetically like from A-Z without retyping them on
the column. Thanks for your time
|
June 23rd, 2009 09:56 PM
by Marcelo
|
2 |
118 |
|
|
Sumproduct - number & text by
Kashyap
Hi, I have number in colB & text in Col C,D
I was trying sumproduct to go the data from colD looking at Col B & C
something like below.. But result is...
|
|
8 |
124 |
|
|
VLOOKUP FORMULA by
Kanmi
I TRIED TO CREATE VLOOKUP FORMULAR TO INSERT DATA FROM ONE SHEET TO ANOTHER
SHEET BUT IT WASN'T GIVING ME WHAT I WANT.
EXAMPLE
I want data entered in sheet1...
|
|
1 |
101 |
|
|
FORMAT by
Tony7659
Hi,
I have the table below for 2008/2009. Now, in another sheet in cell A1 I
have the "Year" and in cell B1 I have the "Period". I need a formula to find
the...
|
|
8 |
176 |
|
|
Counting number of occurances of a word by
Chris the researcher
I need to count the number of times a word shows up in a given cell for which
the number will then show up below the name of the word.
ex. ...
|
June 23rd, 2009 08:49 PM
by RagDyer
|
5 |
121 |
|
|
Conditional Formatting Problem by
mrogozinski
One of my conditional formatting rules is as follows:
If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula...
|
|
8 |
108 |
|
|
Automatic Date Aupdate by
Kanmi
I want to set row above that automatic change date when i change data on each
of the column. For example
Last Update: 6/14/2009 5/19/2009 5/19/2009
...
|
|
4 |
132 |
|
|
data validation drop down list format by
Pwinkle
Hi, I created a data validation range that users enter information into to
create the drop down list. The user does not need to enter information into
all...
|
|
1 |
127 |
|
|
|
June 23rd, 2009 08:29 PM
by RagDyer
|
6 |
124 |