|
|
column names by
erregsec
I got a excell sheet that the column names have been changed from A,B,C,D ect
to 1,2,3,4 ect. I need to change them back to the A,B,C,D ect. How do I do...
|
|
5 |
222 |
|
|
Consolidating sheets by
Faraz A. Qureshi
I have around 12 sheets with data in the same format, i.e.:
Month Client Amount Quantity Branch Product.
What code colud help me to consolidate...
|
|
1 |
111 |
|
|
|
|
2 |
155 |
|
|
|
June 22nd, 2009 07:59 AM
by NOORZAD
|
2 |
92 |
|
|
Lookup by
Gmata
How can i match information from Sheet 1 to SHeet 2 using MODEL NUmber if i
have Model Number in Both sheets.
Thanks
|
|
1 |
115 |
|
|
Text displayed as # in cell by
Tamm
I have a cell that is formatted as text. It's a merged cell with settings for
wrapped text. It will only display # no matter how many characters are typed....
|
|
2 |
94 |
|
|
|
June 21st, 2009 10:23 PM
by JLatham
|
3 |
129 |
|
|
IF..... by
George
Dear all,
The formula below is ok, but only for one row. How to use it for range of...
|
|
1 |
70 |
|
|
|
|
1 |
119 |
|
|
3rd and last Revised WorkBook by
Aussiegirlone
Sorry I took so long, bugger me; "To send attachments just post a new
thread........LOL." Am I that #@%# #@%#
Obstinate is the correct word you used for this...
|
|
3 |
91 |
|
|
URL function by
JoJo
Folks:
In column #1 of my spreadsheet, I have a list of hyperlinks. When I hold my
mouse over these links, the URL (or email address) associated with...
|
|
1 |
68 |
|
|
Truncating Decimals by
RidgeView
I have a macro whereby I have cells each a with number that could be upto 2
decimals in length. Example: A B C
...
|
|
2 |
92 |
|
|
|
|
5 |
80 |
|
|
SIMPLE FORMULA by
andy
Dear all, i hope somene can help - because ive just pulled out my last hair
i'll tryto explain - in column A i have a list of 30 names (which may be...
|
|
7 |
106 |
|
|
"Cannot Empty the Clipboard" in Excel 2007 by
Handy Matt
As I work in Excel and do my cut/copy and paste procedures, many times I have
no difficulties. On occasion, and apparently from nowhere, I encounter this...
|
|
1 |
113 |
|
|
|
June 21st, 2009 04:28 PM
by JerryG
|
3 |
172 |
|
|
Rearranging text data. by
Houston123
I currently receive a file that has a list of client ID and each Client ID
contants a list of codes listed on the same row of the Client ID. I need to
have...
|
|
4 |
110 |
|
|
IF/AND worksheet function by
Fan924
How do I word a worksheet function where both of these is true,
IF C18=C20 AND IF C18=C16
gives a 1, not it gives a 0
|
|
5 |
119 |
|
|
Files won't load from shortcut on email by
Boomer1
I've used Excel for years. A few days ago I couldn't open an Excel file
attached to an email from a coworker. Since then clicking on any shortcut or
an...
|
June 21st, 2009 05:25 AM
by Boomer1
|
2 |
78 |
|
|
|
|
3 |
108 |