Search results for query: *

Thanks SkipVought, that's working fine now WS

Hi , this must be so straightforward but it's driving me nuts... I need to evaluate Region, Area and Type in an excel 2010 pivot table. Aim: I want to group data by Region, and Area in rows. Then I want to be able to 1)count occurrences of Type, while 2)using Type as column Headings, and...

Thank you, I have created a work around using an additional calculated column, due to pressures of time. Thanks again.

Hi, any help most welcome with correcting a formula where I am trying to evaluate several codes in Column G Depending on what code exists in column G I would like to check if either column I or Column J contains data. If data exists based on those criteria, I would like in the target cell to...

Both Thanks very much for sticking with this one. I have finally got a solution, cribbed from a stack overflow post SELECT n.Route, TotalAssets_Calculated FROM (SELECT Route, TotalAssets_Calculated, Count(TotalAssets_Calculated) as cnt FROM myTable3 as t GROUP BY Route, TotalAssets_Calculated...

Still working on this... thanks for your input

Thanks both for your comments, unfortunately I am on other work this week, but hoping to get back to this next week - much appreciated.

Hey, thanks for your assistance Andy, much appreciated !

Hi Andy Seems to be this: Route TotalAssets_Calculated MaxMyCount Anglia 6,003.89 11 Anglia 5,000.00 2 Anglia 6,004.00 1 Anglia 6,000.00 1 East Midlands 4,828.87 10 East Midlands 4,829.00 1 Kent 4,138.42 9 Kent 4,139.00 1 Kent 4,000.00 1

Thanks Andy, have tried with this but seem to be getting identical results for both.. "Mode1" SELECT Route, TotalAssets_Calculated, Count(*) AS MyCount FROM myTable GROUP BY Route, TotalAssets_Calculated; Then running "Mode2" SELECT Mode1.Route, Mode1.TotalAssets_Calculated...

Hi Andy Thanks for this - unfortunately MAX seems to return the highest value within Route rather than the most frequently occurring within Route Anglia 6,004.00 East Midlands 4,829.00 Kent 4,139.00 The results I am after would look like this: Anglia 6,003.89...

In a summary query, I need to return the value that shows up the greatest number of times in a certain column of a table "TotalAssetsCalculated", for each route that is listed in a separate column "Route" I have read that I need to calculate the "mode", and the approach I am using is cribbed...