115 reputation
14
bio website oleymediagroup.com.au
location Melbourne, Australia
age 40
visits member for 2 years, 3 months
seen Dec 17 at 0:26

Mar
22
awarded  Notable Question
Jul
24
awarded  Popular Question
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