| bio | website | alternet.com.au |
|---|---|---|
| location | Melbourne, Australia | |
| age | 38 | |
| visits | member for | 8 months |
| seen | Oct 10 '12 at 22:12 | |
| stats | profile views | 3 |
|
Oct 10 |
comment |
How to lookup a value in a table with multiple criteria @Excellll the product column in merged. AND Yes, tier labels are the same in the real data |
|
Oct 10 |
comment |
How to lookup a value in a table with multiple criteria @adam There is no qty in source table. Location is the header row. |
|
Oct 10 |
asked | How to lookup a value in a table with multiple criteria |
|
Sep 11 |
revised |
Excel AVERAGEIF value > 0 added excel 2010 |
|
Sep 11 |
comment |
Getting a MAX using AVERAGEIFS logic you da man! I've never used teh {} before - how does it change the statement? |
|
Sep 11 |
accepted | Getting a MAX using AVERAGEIFS logic |
|
Sep 11 |
asked | Getting a MAX using AVERAGEIFS logic |
|
Sep 11 |
awarded | Scholar |
|
Sep 11 |
accepted | Excel AVERAGEIF value > 0 |
|
Sep 11 |
comment |
Excel AVERAGEIF value > 0 I have just changed the heading to CBD and use an alternate method of calculating the cell values hence making this solution work perfectly. |
|
Sep 11 |
awarded | Supporter |
|
Sep 11 |
comment |
Excel AVERAGEIF value > 0 I tried this but was getting errors so I gave up. I think it is the only solution that will work . |
|
Sep 11 |
awarded | Student |
|
Sep 11 |
comment |
Excel AVERAGEIF value > 0 I like this for the Tier 1 & Tier 2 but it still leaves out the CBD suburbs. I might have to do CBD differently |
|
Sep 11 |
asked | Excel AVERAGEIF value > 0 |
|
Feb 9 |
asked | Excel Chart not displaying X Axis |