|
|
Insert Cells every other row by
Texas Nuckols
I have this on spreadsheet:
A B C D E F G H
1 # Name (blank) Add (blank) City, St (blank) ZIP...
|
|
1 |
228 |
|
|
|
|
1 |
298 |
|
|
|
|
1 |
286 |
|
|
|
|
2 |
311 |
|
|
Search for text in multiple columns by
tommcbrny
Hello,
I use the following to search a column for names in a list (Sponsors) and
then print the name to the cell if found, otherwise print...
|
|
1 |
248 |
|
|
GETPIVOTDATA by
Anne R
I am trying to create a count of products by location and diposition similar
to below
Location Aging Retain Aging Dispose
Boston 12, 13,...
|
November 11th, 2009 09:42 PM
by Anne R
|
0 |
194 |
|
|
Setting Multiple Variables with a loop by
jlclyde
Is this possible to set mutiple variables with a loop? I want to go
through a range and for each found item I want the variable set. Here
is what I was...
|
November 11th, 2009 09:40 PM
by jlclyde
|
6 |
239 |
|
|
Add-in by
JoeKing
I ahve a spread sheet written in 2003 but need to be able to use it in 2000.
Is there an add-in to allow buttons and other items to work in 2000.
|
|
1 |
283 |
|
|
if then formula by
vdmbqb
Simply put, I have the word "Shipping" in cell A1. In Cell B1 I have a dollar
amount. In cell C1 i have =IF(A1="Shipping",B1)
I am trying to get C1 to return...
|
November 11th, 2009 09:24 PM
by T. Valko
|
1 |
195 |
|
|
Excel 2003 Clipboard Question by
CommMajor
Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste...
|
|
6 |
205 |
|
|
Close all files without exiting Excel by
jco
In Windows 2007, how do you close all the Excel spreadsheets at once, without
closing Excel? I'm looking for the equivalent of "Close All" that was under...
|
November 11th, 2009 09:16 PM
by jco
|
3 |
209 |
|
|
Using INDEX and MATCH in an Array by
Wox
I am using the following formula on a table to return the item in the first
column where the MAX from a portion of the table is located....
|
November 11th, 2009 09:08 PM
by T. Valko
|
7 |
219 |
|
|
Sheet Macro Help Needed by
Joe D[_4_]
Have a macro that creates a new file. In the new file is a tab called
"Review" which has a macro attached to it. The macro is attempting to copy
data from...
|
|
4 |
208 |
|
|
Error 1004 by
tpeter
I am attempting to make a dynamic Histogram and chart. I have recorded the
macro but when I run it the macro breaks and gives me the above error saying...
|
November 11th, 2009 09:06 PM
by tpeter
|
6 |
212 |
|
|
Filter pivot table zero values by
rebecca
We have an Excel data services report pulling pivot charts from an
OLAP cube.
Is there a way to filter the zero values so those lines don't show?
These values...
|
|
1 |
201 |
|
|
Tex-to-column by
Rickster
In Excel 2003...The delimiter is a comma...However, one of the numbers is
above $1,000 and the number includes a comma (1,000 rather that 1000), so
Excel...
|
November 11th, 2009 08:25 PM
by Rickster
|
3 |
220 |
|
|
vlookupformula by
joe@malvern[_2_]
set up a vlookup over a year ago with drop down menus...forgot how/where do I
view the vlookup formula in a given cell?
|
|
1 |
195 |
|
|
XML File IMport to Excel by
Jcraig713
Hello All.
I have an xml file that I import to excel that in some instances, the
record, once imported, shows as more than one row per record. The problem...
|
|
0 |
206 |
|
|
hidden Hyperlink by
expect_ed
If I copy an HTML page from IE and paste it into Excel (2003) the hyperlinks
from the page remain. But if I look at the cell contents/formula there is no...
|
|
1 |
267 |
|
|
Find a Unique code cut and paste by
kingie
Hi,
I have a large list of unique alpha numeric codes in an excel worksheet
comprising 25 columns wide by 200,000 rows deep.
I want to enter a list of codes...
|
November 11th, 2009 08:05 PM
by kingie
|
0 |
196 |