|
|
Normalize/concatenate by
EllenM
Hello,
I have a data set that looks like this:
Sortterm Doc # Main Term CAS # CFR REG #
DIPHTHALATE 7065 DI(2-ETHYLHEXYL)...
( 1 2)
|
March 11th, 2010 05:19 AM
by minyeh
|
10 |
294 |
|
|
|
March 11th, 2010 02:24 AM
by John
|
1 |
168 |
|
|
lookup question by
Art
I have a sheet in Excel 2007 that lists all of the courses we offer. Columns
L to O indicate if a particular course if offered each quarter.
For example, for...
|
|
1 |
143 |
|
|
vintage fashion by
raismisuaween
vintage postcards
vintage mens
vintage audio amplifiers
vintage dolls
vintage definition
|
|
0 |
155 |
|
|
|
|
1 |
126 |
|
|
|
|
2 |
121 |
|
|
|
March 10th, 2010 10:56 PM
by Max
|
3 |
116 |
|
|
Percentage max formula? by
liaper
i need to find out how divide two cells but the answer cannot be more than 150%
for example: I want to divide A2 and A1 abd have the answer be on A3 but the...
|
March 10th, 2010 10:36 PM
by tompl
|
2 |
117 |
|
|
Pivot Table Wizard causes crash by
mike in texas
Hello,
I'm using Excel 2003(11.8316.8221) SP3
When I use the Pivot Table Wizard and press the "back" button to redefine
the range of data. Excel crashes....
|
|
1 |
119 |
|
|
|
|
1 |
178 |
|
|
customize drop-down box by
Art
Is there a way to use Data Validation to create an in-cell drop-down box from
a range of cells...but before displaying that list in the drop-down box, can...
|
March 10th, 2010 09:40 PM
by Art
|
1 |
140 |
|
|
|
|
2 |
151 |
|
|
|
March 10th, 2010 09:09 PM
by DevourU
|
3 |
119 |
|
|
using indirect to return a named range? by
ker_01
I'm having a mental block on how to do this.
I have a boatload of named ranges in my workbook. I have one worksheet that
has two data validation cells and a...
|
March 10th, 2010 09:02 PM
by ker_01
|
1 |
113 |
|
|
SUMPRODUCT and Dates by
Glenn
Greetings,
I am using the following:
=SUMPRODUCT(($D$27:$D$500=C12)*($G$27:$G$500=$K$2)*($G$27:$G$500=$K$3)*($H$27:$H$500="Single")*($B$27:$B$500))
where C12...
|
March 10th, 2010 08:36 PM
by Glenn
|
2 |
94 |
|
|
|
|
1 |
122 |
|
|
Count Cells Within 10 of a Cell Value by
Missbrooke06
I need a formula that calculates how many out of a range of cells are within
10 of another cell. For instance, I have cells F3 through U3. I want to know
how...
|
March 10th, 2010 08:14 PM
by Mike H
|
2 |
133 |
|
|
|
March 10th, 2010 08:11 PM
by Art
|
2 |
182 |
|
|
Import multiple photos into excel by
shanelawler[_2_]
I am trying to create a photo sheet that will allow me to import all photos
in a directory into an excel spreadsheet.
I want it to:
Import all images in a...
|
March 10th, 2010 08:00 PM
by Billns
|
1 |
116 |
|
|
excel number appearances by
longgone
some numbers in excel speadsheet appear like ####### How do I get rid of
them/fix them to show a currency amount
|
March 10th, 2010 07:31 PM
by Mike H
|
1 |
89 |