Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: WildbloodS
- Content: Threads
- Order by date
-
MS Excel Pivots - Same Data used for Columns and Values
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...- WildbloodS
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Excel Nested If Or Statements, returning FALSE or #VALUE
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...- WildbloodS
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
MS Access SQL to return most frequently appearing values.
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...- WildbloodS
- Thread
- Replies: 15
- Forum: Microsoft: Access Queries and JET SQL
