|
|
Vlookup and Data Validation Q by
Seanie
I am trying to use a DataValidation cell value to do a lookup and I
get #N/a
Cell N101 = a Data Validation list value
Lookup formula in O101 =...
|
April 18th, 2010 04:33 PM
by Sheeloo
|
2 |
206 |
|
|
Date question by
Ziggy
Is there a simple formula that will give the difference between two
dates in MONTHS?
Today() - (6-1-2003) = MONTHS
|
|
3 |
220 |
|
|
Linking to other worksheets by
Cav
I have 12 worksheets (Jan - Dec) each containing data for each month. I also
have a summary sheet that i would like to link to the monthly data. On the...
|
|
3 |
258 |
|
|
|
|
2 |
265 |
|
|
|
April 18th, 2010 07:07 AM
by Ziggy
|
2 |
236 |
|
|
Top half of covariance matrix by
aaronmsl
Hi
So I've used data analysis to produce a covariance matrix, however it only
generates the bottom half of the matrix. Since I want to use the matrix with...
|
|
1 |
260 |
|
|
Sorting by
Father John
Hi
I have a spreadsheet with numerous addresses in col. A 1-999
15 Smith Street Jonestown
21 George Street Blacktown etc.
In col B. 1-166 I have the name of...
|
April 18th, 2010 02:05 AM
by JLatham
|
1 |
206 |
|
|
Lookup Question by
MJ
I have a worksheet that has Zip codes that needs to be matched with a master
zip code list with assigned names. One worksheet has a column called “Ship...
|
April 18th, 2010 12:26 AM
by JLatham
|
1 |
240 |
|
|
m4=b4 only if by
Derek
I want to copy data from on cell to another cell, but only if a third cell
has data in it.
|
|
2 |
249 |
|
|
Linking Totals Across Multiple Worksheets by
snowboardbaltimore
I am trying to sum the totals (in accounting number format) across multiple
worksheets onto a single worksheet. I have tried manually creating the
necessary...
|
|
3 |
236 |
|
|
|
April 17th, 2010 06:12 AM
by patbarb
|
6 |
239 |
|
|
|
|
3 |
176 |
|
|
|
|
5 |
203 |
|
|
If function help by
Pam
I have a current formula that I need to nest with another IF formula....
=IFERROR(VLOOKUP(B15,D40:E42,2,FALSE),"Invalid Shipping option")
D40:E42 are shipping...
|
|
6 |
235 |
|
|
Maybe too hard to do? by
LSSTOC Black Belt
Good Day, I have to take (certain) data from one sheet to another if a
particular cell is not blank dynamically.
F400 PROJ...
|
|
2 |
180 |
|
|
Use Vlookup to store formulas? by
patbarb
Hi, I'm trying to figure out if it's practical to use Vlookup to bring back complete formulas to a spreadsheet when you have a ridiculous number of formula...
|
April 16th, 2010 10:20 PM
by patbarb
|
6 |
197 |
|
|
Add text automatically by recognized value by
Peter Gonzalez[_2_]
I'm trying to create a formula where it recognizes the first three digits of
an item number at the same time entering the department name in the cell next
to...
|
|
4 |
224 |
|
|
counting groups of words by
Seller Smith
I have a column of cells that I would like to count the occurances of
duplications of each group of words.
Example: AMIN500S 1
AMIN400EC 9
...
|
|
4 |
221 |
|
|
Converting PDF or HTML to Excel by
JPalmer
Is there a way to take the information in this link:
http://204.65.203.5/public/441280noadd.pdp
and convert it into an excel spreadsheet that separates the...
|
|
2 |
172 |
|
|
Autogroup then sum - can it be done? by
Jessica Robinson
This is what I would like to do, if possible:
Sum the values of column B that correspond with a set of unique row entries
in column A. The sum should go on...
|
April 16th, 2010 08:16 PM
by John
|
5 |
204 |