| Thread | Last Post | Replies |
|
| Elimintae wierd charecters | 25 Sep 2006 22:24 GMT | 1 |
I have the following list, with spaces, charecters and numbers: 12345 54784 N01 121545 N02
|
| Find and Copy | 25 Sep 2006 22:09 GMT | 4 |
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 digits | 25 Sep 2006 22:06 GMT | 2 |
trying to screen out the last 4 digits of a telephone number
|
| Adding actual Cells | 25 Sep 2006 21:45 GMT | 1 |
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 GMT | 2 |
how do I put bullets side by side
|
| Hide zero values in a PivotTable report | 25 Sep 2006 21:32 GMT | 1 |
How do I hide zero values in a PivotTable report. It didn't work what was suggested under the Office site.
|
| Release Memory | 25 Sep 2006 21:28 GMT | 1 |
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 chart | 25 Sep 2006 21:21 GMT | 9 |
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 Randomly | 25 Sep 2006 21:12 GMT | 2 |
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 GMT | 1 |
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 GMT | 2 |
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 label | 25 Sep 2006 20:58 GMT | 8 |
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 Worksheet | 25 Sep 2006 20:48 GMT | 3 |
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 cell | 25 Sep 2006 20:43 GMT | 2 |
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 GMT | 6 |
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
|