Number Filtering

[FARMER]

Hi,

I have a large spreadsheet (a few hundred lines long).

Please reference the data set called "now". I need to calcuate the values shown in "need" as follows:

1) Search the values in Column "A" and focus on only those rows having the lowest value(s). In the example below, rows 4 and 7 are ignored, and corresponding column, B, C, D values are set to zero.

2) Of the remaining rows (3, 5 and 6 in this case), choose the highest value remaining in column B, C, D and set all other remaining values to zero.

Thanks.

Book1
	A	B	C	D	E	F	G	H	I
2	Now	Now	Now	Now		Need	Need	Need	Need
3	2	2	3	1		2	0	0	0
4	3	2	4	1		3	0	0	0
5	2	3	4	2		2	3	4	0
6	2	1	3	4		2	0	0	4
7	4	6	2	1		4	0	0	0
Sheet1

3) Lastly, is there any way to do a macro for this. I need to apply this condition to parts of a spreadsheet...not always all of it.

 

[yee388]

Have you looked at the AutoFilter functionality? You can do that on a selected range, and it's easy to specify criteria for each column... the good thing about Autofilter is that it's easy to reset and chop up the data another way, without re-writing macros.