|
|
Importing CSV Data from Web? by
aandmstudios
I have a CSV formatted report, embedded in an HTML page that I'd like
to automatically import into an excel 2007 spreadsheet. The page,
requires that I log...
|
|
0 |
67 |
|
|
|
|
6 |
124 |
|
|
permutations by
art
Hello all:
I would like to know how to make this calculation. Below is a list of
products and types and prices. I would like to know how can I make that...
|
|
1 |
117 |
|
|
Cell color changes when date gets closer by
Ralph
Hi:
I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that if a...
|
|
2 |
124 |
|
|
|
May 8th, 2009 04:41 PM
by Jeff
|
6 |
126 |
|
|
Adding a zero to the front of numbers by
Connie Martin
I have a column of numbers, over 800 rows. Some numbers are 7 digits and
some are 6 digits. I need a zero at the beginning of all the numbers with 6...
|
|
5 |
112 |
|
|
transpose data by
Darius
I have data in column B from B2 to B3295 now I want to copy (Transpose) the
every 9 values in B column to one row, otherwords: b2: b10 change to c2 to k2...
|
May 8th, 2009 04:27 PM
by Darius
|
3 |
71 |
|
|
conditional formatting using formulas by
Karl
can anyone help with a formula for conditional formatting? here's the
scenario. I have a sheet that i'm using to track dues paid by members over a
period of...
|
May 8th, 2009 04:04 PM
by Karl
|
2 |
105 |
|
|
How to use formula to the Ans by
Sky[_3_]
Hi,
Is there a way or formula in the excel that could help to add the nearest
month to get the figure for Column F.
The month added up can be greater than or...
|
|
4 |
120 |
|
|
|
|
1 |
71 |
|
|
Absolute Reference Changes by
ATChurch
I have the below formula in "sheet2" of a workbook ("Schedule" being the only
other sheet).
=IF(OR(Schedule!$A$5="Totals", Schedule!$A$4="Totals"), "",...
|
|
2 |
88 |
|
|
|
|
1 |
74 |
|
|
Vlookup Question by
gueyo
I have two wooksheets. The first is the original sheet that has part numbers
with pricing. This needs to be loaded into my database. Once done I need to...
|
May 8th, 2009 01:54 PM
by gueyo
|
3 |
86 |
|
|
|
|
3 |
86 |
|
|
Conditional format Order by
Porky79
Hi Guys,
I have a MASTER worksheet that I copy to create a new sheet before
adding data for an individual. I have the MASTER sheet set up with all
the...
|
|
0 |
117 |
|
|
|
|
1 |
57 |
|
|
|
|
1 |
81 |
|
|
macro protection by
Lois
Hi!
Is it possible to protect a macro to prohibit people to run it?
--
Lois
|
|
3 |
68 |
|
|
got #REF! with fomula PRICE() by
Leo
I keep getting a #REF! error with the PRICE() fomula in my spreadsheet, even
I copy and paste the expamle in the excel help.
but if I paste the expamle in...
|
May 8th, 2009 07:52 AM
by Leo
|
2 |
93 |
|
|
|
|
4 |
70 |