|
|
deleting blank rorws by
VRaybandb
I imported some information from a web page and when it loaded it has huge
amounts of blank rows, how can I delete these without doing each small bunch
of...
|
|
6 |
77 |
|
|
Subtotals every "X" number of rows by
clh
Is there a quick, easy way in Excel to do subtotals ever certain number of
rows? In my case I need subtotals every 15 rows. Oh, this is Excel 2003.
I know...
|
|
3 |
89 |
|
|
|
December 10th, 2008 04:48 PM
by CC
|
0 |
109 |
|
|
|
December 10th, 2008 04:38 PM
by Pete_UK
|
3 |
127 |
|
|
SUMIF by
Neil Pearce
Dear all
Please refer to link. http://www.savefile.com/projects/808719857
I need to SUMIF based on two references. Any ideas?
Yours in appreciation,
Neil
|
|
2 |
97 |
|
|
COUNTIF across different spreadsheets by
Kat
Does anyone know if it is possible to utilise the COUNTIF function across 2
or more different spreadsheets... I keep getting a value error when I try....
|
December 10th, 2008 04:36 PM
by Kat
|
2 |
121 |
|
|
excel templates by
Michelle
I have a work created template that I would like to have everyone on the
network see and use. When I copy the template into the directory where all
the...
|
December 10th, 2008 03:59 PM
by Michelle
|
3 |
84 |
|
|
Regarding Arrays by
Raj
Hi
Here is the excel data how my data is distributed.
Incident Description Status Date logged
313 XXXXX ...
|
December 10th, 2008 03:51 PM
by Max
|
5 |
83 |
|
|
|
|
2 |
111 |
|
|
Excel UNC Path opens in Explorer by
alc8833
Currently when I put a UNC path in Excel and click on it, the Path opens in
Microsoft Explorer. I would like the link to open up in "My Computer".
If I use...
|
December 10th, 2008 03:43 PM
by alc8833
|
0 |
83 |
|
|
Excel selects more extra cells by
DGR
When clicking on cells to select on a worksheet, Excel automatically selects
either extra lines or cells. Then when I click above or below, it keeps the...
|
December 10th, 2008 03:43 PM
by Mike H
|
1 |
91 |
|
|
Between two dates by
jen-chi
I have three dates on the spreadsheet and I need to know if the third date is
within the parameters of the first two...
Column J = 03/21/07 (start...
|
December 10th, 2008 03:25 PM
by RagDyeR
|
3 |
97 |
|
|
Transpose Column to Rows by
Pai
I have around 1600 Name along with company
name,Address1,Address2,City,State,Pincode
For Ex:
Mr.hardeep Kanwar
Bi/200
Yamuna Vihar
Dehi
110053
|
December 10th, 2008 03:24 PM
by Pete_UK
|
3 |
80 |
|
|
|
|
1 |
101 |
|
|
|
December 10th, 2008 03:12 PM
by Nikki
|
2 |
101 |
|
|
insert feilds from word document into excel by
Shi Gharib
Hi,
I hope someone could help me on this one.
1- I have around 150-200 files (adobe acrobat, MS word, excel) that contains
different informations.
2- I have...
|
December 10th, 2008 02:58 PM
by Bob I
|
1 |
72 |
|
|
Massive Find and Replace by
Brian D
I have 3000 codes in column A1. I have 3000 company names in column A2. I
have a seperate worksheet that has column F with random codes. I need the
codes...
|
|
3 |
81 |
|
|
Getpivotdata problem by
Al
Hoping you can help.
I have a Getpivotdata function as per below that successfully returns the
relevant data for all of my records with the exception of...
|
December 10th, 2008 02:57 PM
by Al
|
2 |
96 |
|
|
|
December 10th, 2008 02:36 PM
by Ajay
|
2 |
86 |
|
|
Regarding the Arrays by
Raj
Hi
Here is the excel data how my data is distributed.
Incident Description Status Date logged
313 XXXXX ...
|
December 10th, 2008 02:26 PM
by Pete_UK
|
1 |
75 |