|
|
Summary by
Eliz
i have a transaction of a few people with the figures. i can only get the
total amount using the filter. so, i want to have a summary in another
worksheet....
|
March 10th, 2010 03:04 AM
by Eliz
|
2 |
123 |
|
|
Calculating Problem: Desperate :( by
cionnaith
Hi. I have run into a snag trying to figure out how to make one of my cells
calculate the way I need it to. Here is the rundown: I have a column of data
that...
|
|
4 |
248 |
|
|
Excel 2007 Macro/VB Question DDE Question by
MadDog22
Hi,
So I have a column of cells that are the combination of a other
cells in the row and a result of a few "if functions." The value comes
out exactly as...
|
|
1 |
151 |
|
|
COUNTIF across sheets in columns by
meekjj13
I am trying to count names that appear in multiple sheets. All of the names
appear in the column K in 32 sheets. Is there away to do this? Thanks for
any...
|
March 10th, 2010 01:00 AM
by Pete_UK
|
1 |
122 |
|
|
picture by
raismisuaween
picture of
pictures of
pictures of eyes
picture of
pictures of
|
|
0 |
125 |
|
|
|
March 9th, 2010 11:09 PM
by Max
|
1 |
159 |
|
|
Trying to calculate average call length by
pilates_jocelyn
Usually our phone system spits out a report for me, but it's broken right
now... and I have to provide this info to another department ASAP.
I'm trying to...
|
|
6 |
146 |
|
|
|
|
1 |
134 |
|
|
|
|
2 |
165 |
|
|
|
March 9th, 2010 08:50 PM
by Bermie
|
3 |
134 |
|
|
Earliest time in a range by
pete
Hi,
I have a range of dates and times, and the following will give me the latest
time:
{MAX((Data!$D$2:$D$5000=B13)*(Data!$F$2:$F$5000))}
However, I now...
|
March 9th, 2010 08:25 PM
by pete
|
3 |
158 |
|
|
|
March 9th, 2010 06:28 PM
by Eduardo
|
1 |
131 |
|
|
|
March 9th, 2010 05:25 PM
by Eva
|
1 |
147 |
|
|
|
|
6 |
116 |
|
|
connecting formulas by
Chris
I’m working on a Excel sheet where I have to connect two formulas as follows:
A1 and B1 have together a value of 20%. if A1 is 12%, B1 should
automatically...
|
|
6 |
132 |
|
|
matching only once by
Donna[_5_]
If you could help me tweak this.
I am using this formula: =If(COUNTIF(C$1:C$7,A1),"",A1) and I want it to put
in Col B the amounts from col a that do not...
|
|
3 |
136 |
|
|
AutoFill Changing Wrong Value by
Lisa
I'm trying to create an analysis sheet that gathers data from 100 worksheets
within the same workbook.
I want the same cell reference in each sheet, but to...
|
March 9th, 2010 02:02 PM
by Pete_UK
|
6 |
147 |
|
|
I know this is obvious but .. by
Bony Pony[_3_]
I'm just not seeing it this morning!
I have 3 columns:
Col P16 to P500 contains Project Names
Col Q16 to Q500 contains Pricing Mechanism descriptions
Col X16...
|
March 9th, 2010 01:23 PM
by Max
|
3 |
128 |
|
|
VLookup by
L.Mathe
I'm working with Excel 2003 and created a workbook (1 worksheet) to compare 3
columns of data. Each column varies in number of rows, but could have as
many...
( 1 2)
|
March 9th, 2010 12:45 PM
by Max
|
14 |
272 |
|
|
|
March 9th, 2010 10:58 AM
by Stefi
|
7 |
182 |