select a cluster of point from a range based on x and y values

sandcharles · #1 02-15-2015, 11:41 PM

Hi,

thanks in advance.

i want to find from the list the points which come in a particular region.

a1 3728 3077
a2 3867 3816
a3 3995 6134
a4 3995 6427
a5 3957 7534
a6 3874 7746
a7 3459 8373
a8 2925 9077
a9 2312 9077
a10 2298 9062
a11 1898 8361
a12 1667 7941

please look at the picture attached for my requirement.

Logic:

Find max x value and corresponding y. if more than 1 value is max go with max y value.
similarly do it for y
you have the rectangle. find the points which come within this range.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Color-fill a range of cells, based on text in a different sheet. Possible?	unittwentyfive	Excel	2	06-01-2014 06:48 AM
Find and Delete Rows based on a range	damaniam	Excel Programming	2	03-12-2014 06:06 AM
Way to select a range using the mouse on a chart?	omahadivision	Excel Programming	6	12-29-2012 09:21 AM
change values based on cell	ubns	Excel	1	05-21-2012 06:28 PM
comparing values from a range	struct	Excel	1	04-01-2011 07:17 PM