|
|
truncation with imports via html by
jvblue
I am trying import HTML into excell, but if i choose to import the file it
will truncate the excell with 65533 rows.
However if i save the html as .txt and...
|
September 23rd, 2008 10:03 PM
by jvblue
|
0 |
270 |
|
|
Signature or Logo by
Vercingetorix.XIII[_2_]
Is there a way to put something in an excel spreadsheet as a signature or
logo or something to show that you made it?
|
|
3 |
612 |
|
|
VLOOKUP Problems with formula by
treeroot
I have a workbook on the first sheet is my "high priority" my email column is
A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be...
|
September 23rd, 2008 09:59 PM
by treeroot
|
5 |
603 |
|
|
VLOOKUP returns unwanted/wrong values by
wcollatz
I'm using the VLOOKUP function to return data from a named range which
contains several data points (across the row) for several "sites" which are
numbered...
|
September 23rd, 2008 09:57 PM
by T. Valko
|
4 |
1,013 |
|
|
Conditional Sum? by
PaulinaDi
I have a spreadsheet with different columns regarding all the invoices a
certain supplier has given to my company.
I have 15 columns and 3 of them are the...
|
|
2 |
715 |
|
|
signature line by
pdaws
I have created a form in Excel 2002 that requires three different signatures.
I would like for each signature's username to appear in the specific cell
that...
|
|
3 |
696 |
|
|
Conditional Formatting Separate Rows by
Pete
I need to set-up three formali in each row of a 1000 row spreadsheet. The
three forumli a
=A4="x" then B4 : P4 strickthrough, green font
=B4Today()...
|
September 23rd, 2008 09:49 PM
by Pete_UK
|
3 |
713 |
|
|
copying absolute formulas by
MJKelly
Hi,
I have a large number of formulas in a table. All seven days of the
week are represented. Monday has the correct formulas (and includes
absolute...
|
|
1 |
709 |
|
|
|
September 23rd, 2008 09:10 PM
by Smoke
|
2 |
682 |
|
|
Txt to columns by
Spiky
Well, you could record Text to Columns in a macro to shorten the
keystrokes. Or someone could probably write a long, choppy formula
using MID and FIND and such...
|
September 23rd, 2008 08:40 PM
by Spiky
|
0 |
687 |
|
|
Txt to columns by
Learn Excel
I work a lot on the database of the following format which contains just
numbers.
5555 21 38 50 55 164 | 10 5 2 200 ...
|
|
2 |
688 |
|
|
Hyperlink to workbook location by
jaclh2o
Hi
I am trying to hyperlink to an Excel worksheet location from a word
Document. I am following the instructions from help button but I am getting
this...
|
September 23rd, 2008 08:28 PM
by jaclh2o
|
0 |
652 |
|
|
Refresh columns not in query by
vburns
Is it possible to refresh added columns on a worksheet when the columns
included in the query are refreshed?
For instance, I import items along with...
|
September 23rd, 2008 08:17 PM
by Spiky
|
1 |
672 |
|
|
lastname, first name by
plubeski
I have a spreadsheet with 400 names listed lastname, firstname in once cell.
Is there a function in Excel that would create two cells, one cell for...
|
September 23rd, 2008 08:09 PM
by Mike H
|
5 |
700 |
|
|
replying with attachements by
John at Work[_2_]
Hi all.
Is there a setting that would allow me to reply or reply to all when an
email has an attachement, and I want that attachment to go too? Forwarding...
|
|
4 |
677 |
|
|
Sorting Rows and Levels by
Mac
Can anyone help me with this problem. I am looking to sort warehouse
locations by level and row. The locations are as follows: 210064C. The
breakdown on...
|
|
4 |
708 |
|
|
Get Last NonBlank Value by
Scott[_17_]
In the range (B3:E3) below, I'm using FORMULA 1 and FORMULA 2 below to
retrieve the last value that is "NonBlank and Not Equal To Zero".
Both FORMULA 1 and...
|
|
5 |
656 |
|
|
|
|
4 |
754 |
|
|
Maximum Absolute values by
HW
I have a set of values in 4 columns that I need to see as positive or
negative. However, I need a 5th column to show me the maximum of the
absolute values...
|
|
3 |
740 |
|
|
averages for cells by
jatman
i have a spreadsheet that calculates averages, but as i add more columns, it
always calculates the same columns:
B F G H ...
|
|
6 |
652 |