Counting cells in upper x% of range

Rudi · #1 06-17-2016, 09:16 AM

I have a set of cells with different values. The set consists of 20 rows with 5 cells each. Each row belongs, for example, to a share/security.
I now want to count for each share/security how many cells belonging to that share show values in the upper 15% all 100 values.

Is that possible?

xor · #2 06-18-2016, 06:38 AM

Could you possibly upload a file so that we can see how your data is structured?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel-find cells that contain all upper cas	Mamadukes2007	Excel	2	02-06-2016 02:17 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Counting Color in Cells	Alaska1	Excel	7	07-28-2013 04:36 PM
counting occurences of a value in a range but not including 0's nor blanks	virsojour	Excel	0	07-05-2010 01:34 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM