|
|
Date question by
Ziggy
Is there a simple formula that will give the difference between two
dates in MONTHS?
Today() - (6-1-2003) = MONTHS
|
|
3 |
223 |
|
|
SUMIFS using a text range by
Ziggy
I am still new to Excel 2007. I want to start using SUMIFS for their
efficiencies over array formulas. They don’t seem to work the same. I
want to sort by Dep...
|
March 29th, 2010 01:35 AM
by Ziggy
|
2 |
149 |
|
|
SUMIFS using a text rage by
Ziggy
I am still trying to make the conversion from 2003 to 2007. In
particular I'm trying to understand the SUMIFS since they are more
efficient than arrays. I...
|
March 23rd, 2010 05:41 PM
by Ziggy
|
0 |
141 |
|
|
|
|
1 |
60 |
|
|
SUMIFS using a text rage by
Ziggy
I am still trying to make the conversion from 2003 to 2007. In
particular I'm trying to understand the SUMIFS since they are more
efficient than arrays. I...
|
March 23rd, 2010 05:41 PM
by Ziggy
|
0 |
109 |
|
|
Random Values by
ziggi456
Hi
I have a list of people (approx 200) and need daily to pick 20% of these
people on a random search
|
September 9th, 2008 11:55 PM
by Max
|
7 |
91 |
|
|
|
October 25th, 2006 03:30 PM
by Zigball
|
7 |
99 |
|
|
|
|
10 |
88 |
|
|
|
|
8 |
51 |
|
|
|
October 20th, 2006 01:14 AM
by Zigball
|
5 |
51 |
|
|
|
|
2 |
84 |
|
|
VLOOKUP business case by
ziak
Hi - I need help with an issue and it's best to give some background
information first....please read and bear with me!
I am addressing a compliance issue...
|
May 17th, 2007 04:19 PM
by ziak
|
2 |
66 |
|
|
|
|
3 |
107 |
|
|
SUMIF multiple criteria by
Zia
Hi,
I have two columns A and B. A column has Account # and B column has amounts
A B
10 100
11 200
10 300
13 400
14 500
11 600
Now I want to...
|
October 29th, 2008 04:37 PM
by Zia
|
4 |
41 |
|
|
Traspose Column data into Row by
Zia
Hi,
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data...
|
|
3 |
135 |
|
|
|
|
1 |
78 |
|
|
|
October 11th, 2006 07:50 PM
by JNW
|
1 |
54 |
|
|
Question about SumIF by
zhuanyi
Hello,
I know this is really confusing, but...anyway....
Say for example I have 4 columns of data, the first contains, say, the
name of the sales man, second...
|
August 11th, 2006 04:39 AM
by JMB
|
3 |
90 |
|
|
|
|
5 |
95 |
|
|
|
|
0 |
558 |