|
|
Combining Cells by
George Perrotta
I have 4 cells that I need to combine into one cell. One cell has a
time in it. When I combine cells it does not come up as time but a
fraction.
A1 8:30
B1 ...
|
April 12th, 2010 07:10 PM
by tompl
|
2 |
125 |
|
|
|
April 12th, 2010 06:21 PM
by Ephraim
|
3 |
132 |
|
|
|
April 12th, 2010 05:58 PM
by UKMAN
|
2 |
131 |
|
|
|
|
5 |
189 |
|
|
different colour font in same cel by
ILMER57
I have a cell in excel containing a string of text with some characters in
black some in green and some in red. I want to remove all the black text
leaving...
|
April 12th, 2010 04:57 PM
by JLatham
|
4 |
136 |
|
|
Counting Array element by
asingh
Hi There,
i have two columns, strategy, month and third is desired output
STRATEGY month desired output
cta ...
|
April 12th, 2010 03:30 PM
by asingh
|
4 |
149 |
|
|
Format cell based on cell color by
Jim
Is there a way to format the cell in column A "Red Fill" if there is any cell
in that row in columns B through AO that have a Red filled cell?
If not, is...
|
April 12th, 2010 03:00 PM
by Jim
|
3 |
112 |
|
|
using if in a range by
Sai
I am trying to workout numerology in excel:
I have number 1-9 in row - 1
Alphabets A-I in row - 2
Alphabets J-R in row - 3
Alphabets S-Z in row - 4
I wish to...
|
|
4 |
76 |
|
|
Basic Question on autocomplete function by
kimmyhendrix
Hi everyone, my first time on the forum and my first thread. I apologize
if this is already located on the forum here. I tried searching, but
came up with many...
|
|
2 |
132 |
|
|
formating by
JCRICKET
How would I format several cells to change color is one particular cell
equals A?
|
|
1 |
85 |
|
|
Count if if by
JCRICKET
I need to count the number of items that meet a certain criteria in two
different cell arrays. I am having serious trouble figuring this out. I
would like...
|
|
1 |
68 |
|
|
Consolidate excel 2007 by
Glenn
I have cosolidated 26 sheets all in the same book with the sum function, top
row left column. Most of the consolidation worked OK but 4 totals are
incorrect....
|
|
4 |
111 |
|
|
If function with calculation by
Charlie
Hi All,
I need to get a result from the following:
IF B20 = 0,0 IF B2035, 35 IF B20 35=B20
Basically in layman terms if B20 has a value above 0 the...
|
April 12th, 2010 01:35 PM
by Charlie
|
4 |
91 |
|
|
Merge Cells by
CarlainCerebroMode
I Just want to know how to merge via code two cells:
This doesn't work:
oSheet.Range.merge:=true;
|
|
1 |
77 |
|
|
|
|
1 |
93 |
|
|
|
|
3 |
82 |
|
|
sumif.. by
nordiyu
my condition is :
A B C
1 Date Name $
2 15/2/10 John 15
3 16/2/10 ...
|
|
3 |
71 |
|
|
Counting frequency in unsorted data by
PhilC
hi...I'm looking for a function that will count frequency using multiple
variables in an unsorted data set using two variables. I can get the
information...
|
April 12th, 2010 06:31 AM
by PhilC
|
2 |
99 |
|
|
Look for Max and second Max by
Elton Law[_2_]
Dear expert,
Have made a similar post before.
I am looking for the highest and the second high after the first highest.
One of the experts replied me
In Cell...
|
|
0 |
74 |
|
|
Extract if 1 shows up by
Elton Law[_2_]
Dear expert,
I have a if function command, if fulfil will show up 1 in coulmn AD.
I would like to extract if Column AD shows 1, then return figures on the...
|
|
3 |
117 |