formula -- how to divide into groups

jkpd2000 · May 15th, 2002, 12:43 PM

I have a column A with number 1 to 500
Numbers may be repeated.

Now i want to populate another column B with
>360
>270
>180
>90
>30
Current

depending on the value the column A

formula please

[ This Message was edited by: jkpd2000 on 2002-05-15 11:45 ]

Mark W. · May 15th, 2002, 12:48 PM

What do you mean by "populate"? List, summarize (sum, average, count, etc.) or what? Care to provide some sample data and expected results?

[ This Message was edited by: Mark W. on 2002-05-15 11:49 ]

jkpd2000 · May 15th, 2002, 12:54 PM

column A column B
370 >360
363 >360
300 >270
270 >180
190 >180
89 >60
29 current

etc.

Mark W. · May 15th, 2002, 01:07 PM

Ahhh, "categorize"...

=VLOOKUP(A1,{0,"Current";31,">30";61,">60";181,">180";271,">270";361,">360"},2)

[ This Message was edited by: Mark W. on 2002-05-15 12:09 ]

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

May 15th, 2002, 12:43 PM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	I have a column A with number 1 to 500 Numbers may be repeated. Now i want to populate another column B with >360 >270 >180 >90 >30 Current depending on the value the column A formula please [ This Message was edited by: jkpd2000 on 2002-05-15 11:45 ]

May 15th, 2002, 12:48 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What do you mean by "populate"? List, summarize (sum, average, count, etc.) or what? Care to provide some sample data and expected results? [ This Message was edited by: Mark W. on 2002-05-15 11:49 ]

May 15th, 2002, 12:54 PM	#3
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	column A column B 370 >360 363 >360 300 >270 270 >180 190 >180 89 >60 29 current etc.

May 15th, 2002, 01:07 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Ahhh, "categorize"... =VLOOKUP(A1,{0,"Current";31,">30";61,">60";181,">180";271,">270";361,">360"},2) [ This Message was edited by: Mark W. on 2002-05-15 12:09 ]