|
|
|
|
3 |
130 |
|
|
|
|
11 |
271 |
|
|
|
|
1 |
132 |
|
|
|
|
8 |
245 |
|
|
Help with a predictive analytic by
Rachel Costanza[_2_]
I am looking to create a fun dashboard that will tell people how often to
check their social media outlets based on the number of friends / followers
etc...
|
|
0 |
116 |
|
|
Why do I get #### when I Autosum in Excel? by
Otter Daughter
Windows XP SP3.
I am a newbie in Excel.
I am using the AutoSum function. Sometimes, I get correct dollar figure.
Other times, I get a row of ##### signs,...
|
|
2 |
155 |
|
|
nested ifs by
david rose
Hi all,
I am unfamiliar with nested IF statements.
I want to have a formula evaluate the following:
b1=.005, b2 could =-.004 or b2 could =.004
If b1 is ...
|
|
2 |
176 |
|
|
|
January 3rd, 2010 09:13 AM
by Ayushj
|
1 |
174 |
|
|
Sum Products with VLOOKUP by
TWJOHN
Is it possible to sum the product of 2 columns, 1 column being the result of
a VLOOKUP function, without creating a third column for the individual row...
|
|
3 |
128 |
|
|
N/A Error with VLOOKUP Formula - Excel 2007 by
David Scarfe
I have used the following formula to replace N/A with 0, where there is no value to return.
=IF(ISNA(VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE), 0...
|
|
6 |
193 |
|
|
|
|
2 |
132 |
|
|
|
|
2 |
181 |
|
|
|
January 2nd, 2010 11:19 PM
by JLatham
|
9 |
1,017 |
|
|
graphic in excel based upon result by
Mike S
In one of the available templates, there are icons that appear in the results
cell based upon if the result is at or below budget, and also variable icons...
|
|
1 |
145 |
|
|
|
|
0 |
109 |
|
|
|
|
1 |
145 |
|
|
|
|
1 |
244 |
|
|
Finding links to other files by
AAMIFC
Hi
I have an excel workbook were I have copied a worksheet from another file
into. I have removed all referances that I could find to other workbooks,
however...
|
January 2nd, 2010 04:12 PM
by JoeD
|
3 |
97 |
|
|
sumproduct including previous years by
tleehh
=sumproduct(d18:d1000,--(year(b18:b1000)=year(now())))
I need a formula to add all the values in d18:d1000. All the previous years
including current year.
|
|
1 |
128 |
|
|
Which Function(s) should I use? by
Marbol
Hi All,
I want to generate 5 lists using the preference column from raw data which
is in the following format:
Preference Name Club
1 ...
|
|
7 |
132 |