|
|
Issue with pivot table by
varsha12
Hi,
We have a report in which the data appears in a pivot table. After some
time the pivot table is coverted to text. Is there a way to covert it back to...
|
|
1 |
238 |
|
|
conditional format by
Jean-Paul
Hi,
I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?
I know I can do it with conditionale...
|
April 16th, 2010 02:33 PM
by ck13
|
5 |
344 |
|
|
EXCEL by
Giselle
I have two different workbook with different data in each one except for the
social security that might be in both workbook. I want to order excel that...
|
|
2 |
284 |
|
|
Sort blocks of data by
bushwood
Can you assign groups of columns to move together when sorting horizontally?
I have 11 groups of columns each group with an amount column, ideally we have...
|
|
1 |
199 |
|
|
summing based on text conditions by
Totteridge Ram[_2_]
Hi all
I want to sum my "Value" column based on the text condition in my
"Description" column. Whenever the description contains "CRDML" and does NOT...
|
April 16th, 2010 12:53 PM
by Mike H
|
2 |
190 |
|
|
How to count the number of text? by
Eric
There is a list of text from cell A1 to A100, I would like to count the
number of "Mary" within this range, each cell may contain a senstance, such
as Mary...
|
|
4 |
195 |
|
|
kopirovanie bez zvysovania hodnoty by
Toro
da sa niekde generalne nastavit aby pri kopirovani hodnoty v bunke (tahanim
za pravy dolny roh bunky + mysou) sa tato nemenila bez nutnosti držania
klavesy...
|
April 16th, 2010 11:36 AM
by Toro
|
0 |
203 |
|
|
vlookup based on IP range by
Deen
Hi Every One,
I hope you all are doing well, I required your help to resolve my issue in
excel.
On single worksheet i have two different sheet name as 1.IP...
|
April 16th, 2010 10:35 AM
by Deen
|
2 |
208 |
|
|
|
April 16th, 2010 07:06 AM
by Rich
|
0 |
177 |
|
|
|
|
3 |
219 |
|
|
|
|
0 |
206 |
|
|
|
|
2 |
266 |
|
|
How do I compare the stored data in micro by
Help on formula[_2_]
Hi,
I got four columns of stored list of addresses and dates (two for address
and two for dates) which I want to match against each other. The formats of...
|
|
3 |
205 |
|
|
Calculation Problem by
Norm
I want to calculate production numbers
I have the standard number in G2
I have the actual production number in F5
I have the time duration in I5
I need the...
|
|
5 |
281 |
|
|
XIRR range question by
Brad
How can I "trick" excel to use non-continuous cell
I would like to have
=xirr(m3:m4 and n5,d3:d5)
or
=xirr(m3:m40 and n41,d3:d41)
I realize that xirr...
( 1 2)
|
|
17 |
797 |
|
|
|
April 16th, 2010 02:50 AM
by FSt1
|
2 |
217 |
|
|
|
|
1 |
222 |
|
|
Need help with below question by
Prashant
I had this file with me. there were few hiddne formula. i found out one
formula which was =c6*root!$g$3. My Question is whats is the use of this
formula and...
|
April 16th, 2010 01:49 AM
by Pete_UK
|
4 |
232 |
|
|
Excel - Expense tracking-multiple users by
Hilli
Have 7 ppl sending me bi-monthly expense updates via Excel. Then I have to
take all their "new" updated data and incorporate into a Master .xls, which
the 7...
|
|
1 |
169 |
|
|
|
|
2 |
225 |