|
|
|
|
1 |
161 |
|
|
|
|
1 |
149 |
|
|
|
|
2 |
116 |
|
|
Excel date formats by
mmclemore
I have a problem importing dates with 2 digit year format. When importing
dates with a 2 digit year format, the conversion doesn't follow the regional
date...
|
|
2 |
138 |
|
|
Hlookup and sum formula by
SixBowls
I have a table with the months in row 6. Revenue is in row 9 and costs are
in rows 10 through 38. Cell c6 is 1 for January and cell c9 is January
revenue. ...
|
October 23rd, 2009 03:19 PM
by Max
|
3 |
147 |
|
|
markup rates by
CandiC
Below is a formula that I have set up for a multiplier in my "Cost Estimator"
worksheet In column D8 to look up the cost entered in D7 and mark up to the...
|
|
1 |
176 |
|
|
Merging data from 3 columns by
djqsrv
Hi
I have found and am using the formula =A1&B1&C1
And that works fine but I can only get it to work on one row at a time. How
would I get this to work on...
|
October 23rd, 2009 02:11 PM
by djqsrv
|
2 |
105 |
|
|
|
October 23rd, 2009 02:09 PM
by Bob I
|
1 |
106 |
|
|
Auto Naming Worksheets by
Will Cendrowski[_2_]
I have a workbook that has multiple worksheets. I would like to name the
worksheets and used a macro that I found in one of the threads:
Sub...
|
|
4 |
97 |
|
|
Excel will not open by
stade
I am running XP and using Office 2003, have been for several years. Now
Excel won't open. I get a message asking for the Microsoft Office Standard
for...
|
October 23rd, 2009 02:02 PM
by Bob I
|
1 |
99 |
|
|
|
October 23rd, 2009 02:00 PM
by Bob I
|
3 |
89 |
|
|
Reset End Cell - Excel 2007 by
justwondering
Several spreadsheets are only 50 rows or so but CONTROL + END takes me to
cell H57459. The irritation is that the sliding bar on the right is a tiny
one and...
|
|
2 |
114 |
|
|
Outputting comments - Excel 2003 by
DamianIreland
With Excel 2003, is there any way to output comments when creating a CSV
file?
Similarly is there any way to input a specific cell from a CSV field into a...
|
|
1 |
102 |
|
|
Macro to Hide columns by
whatzzup
Good afternoon,
I am trying to create a macro to hide certain columns on a spreadsheet, how
best do i do this, say want to hide columns g, h, u, ac & ae
|
October 23rd, 2009 01:39 PM
by Mike H
|
3 |
122 |
|
|
|
|
0 |
99 |
|
|
Conditional Formula by
MOHAMMED TAIZUM
i am trying to highlight the entire row say if column H has a value greater than 1200. but column H has a formula and gets the input from another...
|
|
1 |
102 |
|
|
address cell where max by
Are
How to know address cell if there are max value
exm :
A B C
1 10 11 15
2 12 16 15
3 13 15 15
|
|
4 |
96 |
|
|
|
|
3 |
94 |
|
|
Concatenate and include trailing blanks by
Mr_Wilf
Hi,
I need to concatenate three seperate Text fields in to one long string, but
keeping each value to 30 char.
eg
A1 "999 Letsbe Avenue"
B1 "Little Doing...
|
|
5 |
172 |
|
|
Pivot tables - 'blank' label by
AS
Hello,
I would like to get rid of 'blank' label that appears in some blank cells in
pivot tables. I just want it to appear blank. thank you.
|
|
3 |
91 |