Advertisement

05.17.2008 at 02:47AM PDT, ID: 23410448
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

formula

hi, ive put a file on eestuff. the formulas on the RAWDATA page just dont seem to be working. they did work until i tried to enlarge the range, adapting the formula to encompass the new ranges. id like the formulas to read the rows of data accurately. the formulas start on column AG. the names for each column are 5 Count, which means they should be a minimum of 5 C grades or better on a row. The grades go from A*, A, B, C, D, E, F, G, U. The remaining columns are all variations of counting grades along a row of data.
Start your free trial to view this solution
Question Stats
Zone: Software
Question Asked By: pete47
Solution Provided By: patrickab
Participating Experts: 2
Solution Grade: A
Views: 0
Translate:
Loading Advertisement...
05.17.2008 at 03:01AM PDT, ID: 21588591

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 03:39AM PDT, ID: 21588663

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 03:39AM PDT, ID: 21588664

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 03:46AM PDT, ID: 21588683

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 03:55AM PDT, ID: 21588703

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 03:59PM PDT, ID: 21591025

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:02PM PDT, ID: 21591029

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:15PM PDT, ID: 21591069

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:18PM PDT, ID: 21591075

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:21PM PDT, ID: 21591079

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:23PM PDT, ID: 21591083

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.17.2008 at 04:26PM PDT, ID: 21591087

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.18.2008 at 12:36AM PDT, ID: 21591850

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.18.2008 at 05:22AM PDT, ID: 21592439

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.18.2008 at 05:27AM PDT, ID: 21592457

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.18.2008 at 10:22AM PDT, ID: 21593329

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
05.17.2008 at 03:01AM PDT, ID: 21588591

Rank: Genius

pete47,

Please upload your file - preferably not zipped.

Thanks.

Patrick
 
05.17.2008 at 03:39AM PDT, ID: 21588663

Rank: Genius

Hello pete47,

I just checked EE-Stuff and found no file there.  Please either upload the file directly into your question,
or try uploading at EE-Stuff again.

Regards,

Patrick
 
05.17.2008 at 03:39AM PDT, ID: 21588664
hi Patrick, im sorry but the file will have to zipped to upload it, unfortunately im working away from home until tonight, which means i cant zip it where i am - i'll zip it and upload it when i get home tonight - thanx for the response. pete
 
05.17.2008 at 03:46AM PDT, ID: 21588683

Rank: Genius

pete47,

It's your lucky day - you've got two Patricks on the case!

Patrick
 
05.17.2008 at 03:55AM PDT, ID: 21588703

Rank: Genius

pete47,

If you upload directly into your EE question, there is no need to zip.

Patrick and I will try our best not to confuse you :)

Regards,

Patrick
 
05.17.2008 at 03:59PM PDT, ID: 21591025
yeah thanx guys but the file is too big to upload directly. pete
 
05.17.2008 at 04:02PM PDT, ID: 21591029

Rank: Genius

Why not make a much smaller edition of your file just so we can see the problem. I very much doubt we need it all to see the problem. Apart from which I hate zipped files!
 
05.17.2008 at 04:15PM PDT, ID: 21591069
okay guys ive uploaded the file into eestuff as a zipped file - i'll also copy the formulas below with the ranges pete
 
05.17.2008 at 04:18PM PDT, ID: 21591075
=MIN(COUNTA(D4:AD4)-COUNTIF(D4:AD4,">C"),5)

this formula should count 5 A* - Cs if a row has 5 A* - Cs along a row even if there are more than 5 grades greater than 5.

pete
 
05.17.2008 at 04:21PM PDT, ID: 21591079
{=IF(COUNTIF(D4:E4,">C")>0,"",COUNTA(D4:E4)+MIN(COUNTA(F4:AD4)-COUNTIF(F4:AD4,">C"),3))}
this should count 5 A* - Cs including Maths & English ie, two grades greater than C should be the first two columns in D:E, then another three, even if there are more grades greater than C along a row. pete
 
05.17.2008 at 04:23PM PDT, ID: 21591083
=MIN(COUNTA(D4:AD4)-COUNTIF(D4:AD4,">C"),12)
this formula should count grades greater than C up to a maximun of 12 grades.

by the way all these formula's rage is D4:AD4, as far as i can see they should work but they count the required count irrespective of grade. pete
 
05.17.2008 at 04:26PM PDT, ID: 21591087
Also, the RAWDATA sheet is the input sheet, the collection page just calls rows based on anchor lines using code - hopefully, that page works fine pete
 
05.18.2008 at 12:36AM PDT, ID: 21591850

Rank: Genius

pete47,

It seems to me that the main problem you have is that your supposedly 'blank' cells are not in fact blank at all. They all have spaces in them, thus they are counted as cells containing something rather that blank. I have deleted the blank cells and your formulae react accordingly.

I have not uploaded your file again as it's not needed for the task of deleteing blanks!

Hope that helps.

Patrick
Accepted Solution
 
05.18.2008 at 05:22AM PDT, ID: 21592439
hi, thanx Patrick, how do you delete blank cells? pete
 
05.18.2008 at 05:27AM PDT, ID: 21592457
hi - or rather - is there code that i can put in a button that deletes all blanks without having to pick my wat through the entire sheet - and why didnt this problem exist before I extended the rages of the formula? could it be something to do with the fact that I pasted in all the present data? sorry about the weight of questions pete
 
05.18.2008 at 10:22AM PDT, ID: 21593329

Rank: Genius

Pete,

I'm afraid I've been out all day today at our grand-daughter's baptism. Just seen your questions.

My apologies for my poor explanation. The cells only 'appear' blank but in fact they've got spaces in them. Just how they got there I cannot guess. So all you need to do is delete the contents of the apparently blank cells - to get rid of the spaces which of course are invisble.

Meantime thanks for the grade.

Patrick
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628