|
|
Text to Columns issue by
Bean Counter[_3_]
Hi,
The accounting program that I use does not have a well formatted excel
download, so it is better to dump the data into notepad and then format it.
I...
|
|
2 |
340 |
|
|
Referring to a portion of a column by
LewisM
Knowing that $A:$A can be used in a worksheet function to refer to all cells
in column A. Is there a way to refer to all cells below a starting point?...
|
|
1 |
314 |
|
|
reminder in excel by
S4U
Hi frnds
I want to get Reminder message box automatically, according to the date and
time in Excel worksheet. Pop up have come on my task bar even my excel...
|
May 27th, 2010 11:50 PM
by S4U
|
0 |
260 |
|
|
|
|
1 |
328 |
|
|
|
|
1 |
441 |
|
|
dates not recognised by
DL
Hi,
From a third party source, I receive data in ".csv" form.
When I open the file in excel, everything would work great on my old
computer (with vista). ...
|
|
1 |
302 |
|
|
rental equipment invoice by
deholmes
I am trying to create a equipment rental invoice using one spreedsheet as the
data base, I am stump on hoe to make the cell that will contain the charge of...
|
|
1 |
268 |
|
|
Partial editing of cell contents. by
Twinspar
I am developing a spreadsheet to be distributed to numerous individuals for
updating and returned to me to be compiled. I have a column for account
number...
|
|
1 |
310 |
|
|
|
May 27th, 2010 11:30 PM
by dlw
|
2 |
380 |
|
|
naming worksheet tabs by
SHARON
i need to name a worksheet tab with a name that is more characters than
allowed. Can you make the tab larger to accommodate a larger tab name?
I know you...
|
|
1 |
273 |
|
|
|
May 27th, 2010 11:25 PM
by dlw
|
2 |
353 |
|
|
|
|
2 |
320 |
|
|
|
|
1 |
328 |
|
|
|
|
0 |
280 |
|
|
Formula to return text by
casinel1
Need some help here. I am using excel 2007 and I am merging cells - I cannot
figure out a formula to give me the text in 91 columns below the previous
text....
|
|
1 |
293 |
|
|
include sheet name in formula by
pm
I have multiple sheets in a file and i'm trying to include the sheet name in
a cell with a formula but not sure if this can be done - for instance:
Company ...
|
May 27th, 2010 11:14 PM
by pm
|
2 |
316 |
|
|
Convert numbers to hrs: min by
da
Hello
How can I convert the following numbers into hrs:min?
I have tried every possible format (including custom) and I do not get the
results I want (e.g....
|
|
2 |
286 |
|
|
IF Statement Yes/No by
Rod
I am trying to write and IF Statement which will give me a "yes" if over 50%
and a "no" if under 50% for below table
Percent resolved
29%
38%
94%
67%
74%
63%
|
|
2 |
252 |
|
|
Macro from cell specific to whole column by
Bean Counter[_3_]
Hello All,
I have recorded the following macro...
ActiveCell.FormulaR1C1 = "=RIGHT(RC,1)"
Range("O286").Select
ActiveCell.FormulaR1C1 =...
|
|
4 |
398 |
|
|
Match pairs of date in cells by
whatzzup
Good day, i would like a solution to this problem. i have a set of data in a
spreadsheet, these could be repeated, what i would like to display pairs of...
|
|
0 |
257 |