|
|
|
|
1 |
109 |
|
|
|
|
7 |
150 |
|
|
Comparing Two Sheets by
Pete Petersen
I want to compare two sheets:
1st sheet
Customer Date of Last Purchase
2nd Sheet
Customer Email Address Fax Number Market Segment Rep
I want to...
|
April 7th, 2010 10:04 PM
by joahusa
|
2 |
123 |
|
|
Summing 2 columns based on variables by
Steve
This replicates through hundreds of rows.
I need the total hours scheduled by day based on the 0 or 1s in the cloumns
, and the # of variable hours in the z...
|
|
3 |
146 |
|
|
conditional formatting? by
Jennifer Burch
I have a sheet that has a formula that calculates the dates of cleanings, i have made a conditional format so that the dates that are coming up and past month...
|
|
1 |
156 |
|
|
Why won't text show in SOME cells? by
hollyw25
I have the following text formatted as Word Wrap, Text, Top Align, Left
Align, but all I get in cell is ############. This has worked in other cells
in the...
|
April 7th, 2010 08:26 PM
by JLatham
|
3 |
89 |
|
|
Changing coler of tracking cells by
marthajennings
When I use "track changes" the changed cells are outlined in lavender which
is really hard to see. Is there a way to change the highlight color to a
darker...
|
|
0 |
142 |
|
|
@Count by
MAD
I am using Excel 2003.
How do I count rows/column with only text in it. Ex: I have 25 rows where
column "B" says "PO Received" in each cell. I tried...
|
April 7th, 2010 07:48 PM
by JLatham
|
3 |
107 |
|
|
Find Earliest Date by
Elaine
Hello,
I have 2 dates, not in any order. I would like to create a formula to give
me the earliest date of the 2.
Example:
A B ...
|
|
6 |
209 |
|
|
editing a hyperlink by
egildone
I have a stock symbol MED in A1. In A2 I have inserted the following link:
http://www.investors.com/StockResearch/StockCheckup.aspx?symbol=
I want to...
|
|
2 |
121 |
|
|
Remove Arrow by
Elton Law[_2_]
Dear Expert,
Got system generated files ...
.HSI
0941.HK
2828.HK
Is there any functions that can let me capture the content only?
That is no "" and ""...
|
April 7th, 2010 04:37 PM
by John
|
2 |
110 |
|
|
|
|
5 |
90 |
|
|
IF equation will not calculate by
Chuck
I have the following equation: =IF(J12="Prospecting",X12,"") and this is odd:
1. Prospoecting is taken from a pulldonw list.
2. I just abbreviated the word...
|
April 7th, 2010 03:51 PM
by Chuck
|
1 |
101 |
|
|
|
|
3 |
129 |
|
|
Using Worksheet Name by
Akhil Goel
I am having multiple worksheets in an Excel file and now I want to use the
name of each worksheet in a new worksheet in the same file.
Is there a formula...
|
|
3 |
147 |
|
|
Sumif weekday by
Sungibungi
I'm trying to sumif different days of the week. Table is setup as below:
A. Date Date Date Date Date ......
B. Data Data Data Data Data ......
I know that...
|
|
3 |
97 |
|
|
Formatting background colors by
Randy
Is there a formula I can use to change the background colors on specific
cells? I want to change the color on the even rows of 4 columns (A:D) to
gray. I...
|
April 7th, 2010 12:38 PM
by Stefi
|
1 |
138 |
|
|
|
|
4 |
120 |
|
|
|
|
1 |
114 |
|
|
count identical values in 2 rows by
Piet[_2_]
I use Excel 2007
I have a table of about 50 columns and 60 rows.
Each row must be compared with the first row of the table:
Is there a formula, that counts...
|
|
7 |
111 |