|
|
Pivot Table Columns by
CherylK
I have a two rows of labels but the second row of labels I want them in one
column not across as a column heading as I am using the column headings for...
|
|
2 |
125 |
|
|
Conditional Formatting by
vmohan1978
Dear All,
I am preparing a compartive statement i want to highlight the max and min a
group of cells.
quote-1 quote-2 quote-3
100 150 200
like this upto...
|
|
3 |
140 |
|
|
right syntax by
pls123
hello all !
can anybody show me the right syntax for this..
='Sheet1'! & D14 & 100
...so it could be for example...
the cell L100 or BR100..
it...
|
|
8 |
216 |
|
|
|
|
1 |
159 |
|
|
sorting numbers by
Donna[_5_]
Could you help me in sorting numbers.
In column c I have the following numbers and it sorts it like this.
03
11
113
12
15
30
303
|
|
2 |
122 |
|
|
|
|
3 |
202 |
|
|
averaging a range by
suprsonic
How do I average a range of numbers between two criteria? For instance, I'd
want to average only numbers greater than 5 and less than 15.
|
|
4 |
178 |
|
|
Match data by
Nadine
I have some data I need to have returned if it matches something else. The
data pictured below is in worksheet 2. In cell A2 of worksheet 1 is 153.
The...
|
|
4 |
193 |
|
|
|
|
1 |
111 |
|
|
expand row to fit by
Peter
Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra...
|
|
1 |
123 |
|
|
|
|
2 |
132 |
|
|
|
|
1 |
125 |
|
|
|
|
2 |
148 |
|
|
Auto update worksheets by
jrrock26
I'm currently using excel 2003 and am trying to figure out how to update
multiple worksheets within the same workbook by just inputting data into one
sheet....
|
|
2 |
177 |
|
|
IF, THEN HELP by
Grammie
I have a rate chart which covers different values, such as:
If the rate is between 32.00 and 33.99 then the cost is multiplied by
38% (1.38).
If the rate is...
|
|
5 |
162 |
|
|
time format from hh:mm:ss to h:mm by
Diana
I have been trying forever and no luck at all!!!
I have changed the the whole column under format cell/Number/Category/time
and selected 13:30 (english USA)...
|
|
1 |
125 |
|
|
|
|
7 |
213 |
|
|
Percentages breakouts for Ranking by
casdaq
I have this request where it is taking several locations and eight different
metrics but weighting them differently depending on their category to get an...
|
May 5th, 2010 09:29 PM
by casdaq
|
1 |
96 |
|
|
|
May 5th, 2010 09:21 PM
by MM
|
3 |
174 |
|
|
|
|
1 |
130 |