|
|
macro works - very quick by
driller
hello,
for sure again this is another count of appreciation.
i have this very good macro that works for sheet1 only. What is the syntax
to modify this nice...
|
|
6 |
153 |
|
|
|
|
2 |
116 |
|
|
System Freezes using excel by
Jan
Why does my system freeze up when working on an excel sheet. It doesn't
happen with other programs, just the excel
|
|
4 |
119 |
|
|
If value, then display underneath value by
puiuluipui
Hi, i have in C10 a value. This value is changing I need a code to look in
C10, see what is in this cell, and to search for that value in A1:L1, and if
it...
|
|
3 |
103 |
|
|
Controls Toolbox by
Gene Augustin
MAC Powerbook G4, OS 10.5.6
Office 2004, Excel 2004 Version 11.5.3
I have a file that a supplier furnished me that uses the "CONTROLS TOOLBOX".
I found the...
|
|
0 |
141 |
|
|
Reminder by
Misho
In May data I want Excel to remind me for each row if the any rows got the
following applicable conditions:
1- If the H col. cell have the text (offer) and X...
|
October 10th, 2009 03:28 PM
by Misho
|
0 |
98 |
|
|
Formula text in woorksheet cell by
mexmex
I am entering a formula for a list of cells. When I write the formula and
enter it the formula shows up in the formula bar but another text style
formula...
|
October 10th, 2009 02:43 PM
by mexmex
|
2 |
98 |
|
|
Normalizing/Standardizing Data by
Stumped
Hi,
I am comparing data from 2008 and 2009 but want to ensure I am not comparing
apples & oranges. I am hoping some one can help me.
2009:
10 projects...
|
|
2 |
117 |
|
|
Validation a character in a string by
coolmale001
Can any one help me setup a formula for verifying a character in
string with a condition
for eg.
if in cell A2 AACFA4928P and i want to verify is the fourth...
|
|
1 |
129 |
|
|
XML Import Parsing error by
Jeff
I have created an xml file, and some elements contain weblinks w/parameters.
Excel hiccups when it encounters the &.
How can I make it where Excel's XML...
|
October 10th, 2009 10:50 AM
by Jeff
|
1 |
141 |
|
|
|
October 10th, 2009 10:48 AM
by lm
|
1 |
118 |
|
|
If-format problem by
puiuluipui
Hi, i have this code that retrieve : Rate 1, or Rate 2.....from E6:Q6 if
there is something in E8:Q8. The code is working ok, if in E8:Q8 is something
like...
|
|
0 |
82 |
|
|
sustain numbers with double quotes by
driller
Hello,
I tried to assure my numbers in text to visually remain as text as it is
by placing double quotes on the left & right side of each number - for...
|
October 10th, 2009 10:40 AM
by driller
|
7 |
142 |
|
|
Pointer and Cell by
RussL
While I am populating the cells, I keep having a problem with the data going
back to a cell wherever the pointer was last engaged. This ends up
overwriting...
|
|
1 |
103 |
|
|
Formula Error by
Shannan
Ok, i've been posting today about the following formula, which was giving me
a "VALUE!" error. We figured out that it was because one of the cells had a...
|
|
4 |
111 |
|
|
|
October 10th, 2009 03:32 AM
by CVinje
|
5 |
145 |
|
|
advance filter by
Alberto Ast[_2_]
I have a table with advance filters... in one of the column I have different
values as follows
ABC
ABCDE
ABCDEF
Since all start with with ABC, If I put ABC...
|
|
6 |
144 |
|
|
muliple criteria filter by
BNT1 via OfficeKB.com
hi
out of my depth with this formula, that was kindly supplied by this forum.
this was to put in helper column to isolate "307" in a group of numbers in...
|
|
1 |
102 |
|
|
|
October 10th, 2009 12:36 AM
by David
|
0 |
117 |
|
|
|
October 10th, 2009 12:14 AM
by Riketa
|
2 |
123 |