|
|
|
May 5th, 2010 04:35 PM
by Bob I
|
1 |
274 |
|
|
Two different totals in one cell by
something68
C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0
As you can see, “A” (shown in columns D and L) and “AL” (shown...
|
|
2 |
343 |
|
|
How do I create a formula to remove dashes? by
jackierae17
I'm new to Excel. I have a huge inventory spreadsheet where I need to change
a column to reflect the following.
"P01-02-C-1" should become "P102C1" (remove...
|
|
5 |
218 |
|
|
|
|
1 |
209 |
|
|
|
May 5th, 2010 02:41 PM
by nc
|
0 |
206 |
|
|
|
|
2 |
217 |
|
|
Highlight on Date Problem by
Lise
Hi everyone
I have the following in conditional format in column A
=I54-TODAY()=60 if true highlight Red
This is working in most cases but for some reason...
|
|
3 |
230 |
|
|
Opening a sheet by
Eric
When I open up a named sheet sometimes it opens and then closes imediately
shutting down excel all together and then restarting. What is the problem?
It...
|
May 5th, 2010 02:24 PM
by Eric
|
0 |
180 |
|
|
|
|
1 |
212 |
|
|
Formating cells by
Shazza
Hi Sharon,
Tricky formula situation here....
I wanted to change cell colour when certain cells of the workbook are filled
in...I have formatted cells to...
|
May 5th, 2010 01:56 PM
by Shazza
|
0 |
196 |
|
|
sort 2 columns alphbetic and make dictionary by
Mahmoud Mustafa[_2_]
I'm Mahmoud from Egypt
and recently joined to ur group
I have a problem with excel file , and need help from u or anyone can help
to solve the problem
I...
|
|
2 |
275 |
|
|
Splitting cells by
fazz
in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns
|
May 5th, 2010 01:24 PM
by fazz
|
5 |
201 |
|
|
Time Stamp by
Ken
I have a dynamic stock quote in cell "B2" ... in cell "C2" I want to record
the exact time that the stock price FIRST reachs a certain price. How do I
have...
|
|
2 |
206 |
|
|
Autofill by
dewheatley
I'm having a problem with autofill. I can drag and drop but when I want to
see the options, before I can mouse over to the options box, the box vanishes
as...
|
|
2 |
187 |
|
|
worksheet sliding when cell is tabbed by
whatzzup
Good morning, i have a problem where i select a cell and by using right or
left arrow the work sheet move rather than the cell, normally when you tab a
cell...
|
|
2 |
189 |
|
|
|
|
3 |
223 |
|
|
2007 Pivot Tbl to Access Conversion Issues by
LindaSD
I have a large number of 2003 Excel Pivot Tables that connect via odbc to
2003 Access queries. I recently converted one database to 2007. I then
converted...
|
|
1 |
274 |
|
|
AVERAGEIF by
Sasikiran
Dear,
I am struggling with AVERAGEIF formula which calculates the average of data
of one location without including 0 values.
In the below example, would...
|
|
4 |
169 |
|
|
Recognizing an Unstable Result by
Ken
In Column "B" I have a list of results. Some of them have the result of
"#VALUE!".
I would like these cells to be represented in Column "C" with the result...
|
|
2 |
175 |
|
|
Wingdings 2. Check Mark (P). by
Khalid A. Al-Otaibi
Hello;
I set the Font into Wingdings 2, and put a formula =IF(G8="",,"P")
This to put a check mark if Cell G8 is filled with any data,
Now if there is any...
|
|
1 |
350 |