|
|
Ytd formula by
Michel
I have a database in a workbook which is increasing on a daily basis. the
column consiste of e.g
Date country T.operators Rm Type Qty Amount etc
I have a...
|
May 19th, 2010 07:39 PM
by Michel
|
0 |
176 |
|
|
text change by
John
I'll try this again as I accidentally hit the enter key after typing the
subject. In a spreadsheet I have all of my staff listed by their abbreviated
names...
( 1 2)
|
|
13 |
456 |
|
|
Paste Special function and Hyperlinks by
Madphea
I am creating a 'Parent' Workbook which lists a whole load of documents which
are hyperlinked to PDF files of the actual document. I need to create a few...
|
|
0 |
189 |
|
|
|
|
1 |
282 |
|
|
Converting A String to a Column of Data by
carl
I have some strings like this (some are as long as 4000 separated values):
A;AA;AAI;AAP;AAPL
I am looking for a way to convert these strings into column data...
|
May 19th, 2010 06:21 PM
by carl
|
2 |
208 |
|
|
|
May 19th, 2010 06:19 PM
by Billns
|
4 |
562 |
|
|
Excel Code by
A. Mart
I am trying to put together a spread sheet that will allow me to type a
specific letter and a 9 digit code will appear once I enter the letter.
|
|
1 |
168 |
|
|
|
|
1 |
201 |
|
|
|
May 19th, 2010 03:31 PM
by Matt
|
3 |
307 |
|
|
Sorting the pivot table field list by
diewue
How do I sort the pivot table field list?
It looks like the soft order is always the order of the data source.
The related radio-buttons in the...
|
May 19th, 2010 03:21 PM
by diewue
|
4 |
172 |
|
|
if function (if more that 7 nesting) by
keflow
End result is to compare prior year numbers to current year to date
sheet 1 has the following columns-- sheet 2 has history-each month totals
for a number of...
|
May 19th, 2010 03:18 PM
by kathy
|
2 |
167 |
|
|
|
May 19th, 2010 03:17 PM
by diewue
|
0 |
181 |
|
|
Pasting formulas advances cell reference by
Derek M[_2_]
Hi
When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.
A1 formula ='Feb 2010'!C18 but when i...
|
|
2 |
237 |
|
|
lookup and placeholder function by
Cam
Hello,
I have a sheet with date (some have the same date), order# (6 numeric
digits, etc.. I want to add another column to look if there are more than one...
|
|
2 |
169 |
|
|
|
|
1 |
158 |
|
|
|
|
1 |
137 |
|
|
copy rows to another file by
climate
Dear Experts
I have following code,i need to copy desirde rows to new file (r.xls) on
sheet 1.
This code is able to copy desired rows from active sheet to...
|
|
3 |
147 |
|
|
copy rows to another file by
climate
Dear experts
I have following code which Mike has wroted, i need to change this macro,
this code is able to copy several rows (based on values on CoLG) to...
|
|
0 |
147 |
|
|
copy rows to another file by
climate
Dear experts
I have following code which Mike has wroted, i need to change this macro,
this code is able to copy several rows (based on values on CoLG) to...
|
|
0 |
156 |
|
|
IF, AND for different Columns by
texansgal
I have a worksheet for a meeting that I am trying to get to where I can use
the formula's and it will calculate as soon as the data is pasted from
another...
|
|
3 |
168 |