|
|
Sorting Columns by number of characters by
NicoleS
I'm using Excel 2007.
Is it possible to sort a column by the number of characters on the line?
I track part numbers - which vary in length and can include...
|
|
1 |
389 |
|
|
Excel 2007 by
LogJAM57
How do you change the rows to columns and the columns to rows in a spread
sheet when copying, using excel 2007. I believe with excel 2003 you could do
it...
|
May 5th, 2010 09:54 PM
by Bob I
|
2 |
204 |
|
|
Excel 2007 Crashes when Saving to .xls by
Diana
I have a workbook with a large amount of VBA that works just fine in Excel
2003. However, when I open the file in Excel 2007 and try to "Save" or "Save
as"...
|
|
1 |
355 |
|
|
|
|
3 |
226 |
|
|
Validation list in data entry form by
Steve M
Hi
I have a data validation list which I use in the spreadsheet for the user to
select from the drop down. I would like the user to be able to user a data...
|
|
4 |
347 |
|
|
Excel and SQL Server by
Rob
I need to populate a column in Excel from SQL Server based on data in an
existing Excel column. For example if I have a spreadsheet with employee ID’s
in a...
|
May 5th, 2010 07:18 PM
by FSt1
|
1 |
234 |
|
|
|
|
6 |
247 |
|
|
Stop People Copying a Workbook by
Deborah
Is this possible (Excel 2002)
We have a workbook in a shared folder which many need to have access to
update the info in it. Problem is there are now 3...
|
|
8 |
331 |
|
|
subdividing a column by
conniemae
I am trying to develop a spreadsheet that I can list 2 columns of information
under each month column...Is this possible in Excel?
|
May 5th, 2010 06:34 PM
by Bob I
|
1 |
151 |
|
|
simple loop needed please by
Alan
basically
i want the macro to enter values 1 to 5 for range g2:g6
then move onto row h2:h6 and start with 2 and place i and the bottom
so it should look...
|
|
1 |
222 |
|
|
Help with Google Groups search by
Joe User[_2_]
Forgive me for this off-topic request. But since it impairs my ability to
help people with Excel questions, it might not be entirely inappropriate. I
have...
|
|
0 |
173 |
|
|
Plotting by
Dperrilloux
I have an excell spreadsheet that is used as an schedule. it was built using
office 2003 and I could send it to the plotter using some modified changes.
We...
|
|
0 |
153 |
|
|
Hiding VB Code by
baz
I am using Windows XP and Excel 2002.
I have written a small code in THIS WORKBOOK.
I want to know if there is a way to protect anyone else from going into VB...
|
May 5th, 2010 05:51 PM
by baz
|
4 |
201 |
|
|
Data Validation by
Gotroots
Hi,
I need to prevent data from being entered into a cell if there is already
data in any cell left or right of it in the same row.
Thanks
Gotroots
|
|
1 |
163 |
|
|
Use Find and Replace in Excel by
tenspeed2
I have the following in cells after using a formula. #INVALID_DATA. The
reason is there is no data in the cell. If i use the Find and Replace to
remove the...
|
May 5th, 2010 05:31 PM
by Reeza
|
1 |
175 |
|
|
AVERAGE ARRAY by
vukgar
I would like to average the 1st 7 numbers in an array (E2:E63), in the next
colum I need to average the 1st 30 numbers of E2:E63). I have tried using...
|
|
1 |
264 |
|
|
Formula To Split Name by
Kiley
I have a list of names in colum B, that I would like to split into column C
and D. The names in column B have a first name, middle intial and a last
name. I...
|
|
5 |
203 |
|
|
Pivot Table With Text Values by
Tarig
Hi,
Is there any way that I can use Pivot Table or any other similar function so
that I can get text not numbers in the ∑ Values field?
Sure my intention...
|
May 5th, 2010 04:54 PM
by Tarig
|
0 |
182 |
|
|
Excel chart does not start at zero. by
Steven
I have a chart that shows shipped quantities vs month/year date, with the
date on the x-axis. My manager, who is expert at finding trivial things for
me...
|
May 5th, 2010 04:43 PM
by Steven
|
1 |
257 |
|
|
|
|
2 |
217 |