Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Elimintae wierd charecters25 Sep 2006 22:24 GMT1
I have the following list, with spaces, charecters and numbers:
12345
54784    N01
121545    N02
Find and Copy25 Sep 2006 22:09 GMT4
Good Morning,
I have a list of over 2000 items with several columns per entry.  I was able
to use the 'find' function to find entries with a specific word in them and
where they were within the list but now I'd like to isolate those item, copy
how can I set up a custom filter to ignore the last few digits25 Sep 2006 22:06 GMT2
trying to screen out the last 4 digits of a telephone number
Adding actual Cells25 Sep 2006 21:45 GMT1
Hello! I would like to add actual cells, and not their values...
example :
in $A$1 I have 1
in $A$2 I have 1
how do i put bullets side by side?25 Sep 2006 21:38 GMT2
how do I put bullets side by side
Hide zero values in a PivotTable report25 Sep 2006 21:32 GMT1
How do I hide zero values in a PivotTable report. It didn't work what was
suggested under the Office site.
Release Memory25 Sep 2006 21:28 GMT1
I have a macro, and it uses an array that is pretty big Array(7000,361,26)
So if I call the macro that uses this array over and over, is there any way
to "erase" the array so the memory is used more efficiently and the macro
runs faster?  Like a clear memory command?
how to make a bar chart25 Sep 2006 21:21 GMT9
I have a column on my excel file that has ages of different people. I
would like to make a bar chart that gives me the no. of persons on the
Y axis, and different age-groups on the X-axis(for example 30-40,
40-50....)
How to Switch between different work sheets Randomly25 Sep 2006 21:12 GMT2
If i want to Open Specific Work Sheet without using CTRL+Page Down or
CTRL+Page Up, how to do that? since if i use CTRL+Page Down or CTRL+Page Up i
should move in Sequential Order, i want to know how to Open work sheet in
Random Order
V lookup in separate TABS!25 Sep 2006 21:12 GMT1
can anyone tell me how to count the number of times an item "i.e no, yes,
maybe" appears in a column, but the catch is how do I do it when they're on
separate sheets? The counted number is displayed in a different tab than the
values counted.  Is it a v-lookup, but how do i ...
I get a comma instead of a decimal why ?25 Sep 2006 21:08 GMT2
I believe this is an old version of exexl
It has been working fine untill today.
When you type 19.5 you get 19,5
it will not change no matter the number format
Custom Field label25 Sep 2006 20:58 GMT8
How can I enter a formula in a cell, but but a custom text label be displayed
in the cell instead of the value of the formula?
Thanks
New Worksheet25 Sep 2006 20:48 GMT3
Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them.
how do i eliminate leading 0 in a text cell25 Sep 2006 20:43 GMT2
I have ID numbers that are alpha numeric.  Some are all numeric formatted as
text, others are actual alpha numeric combinations.  Most all have leading
"0s".  I want to easily eliminate them.
Translation/formula.25 Sep 2006 20:34 GMT6
I'm having some trouble with my excel. I have lines such as this:
4Nm 24V AC/DC 2/3 PKT. IP55 90 sek
I need to change the "sek" into "sec" so that it is the only element in the
sentence being changed (i.e. if I later on copy-paste, the "sek" will always
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.