setting ranges with something like -Lookup?

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

papa jonah

I have a table that looks something like:

Group variety
1 taco
1 burrito
1 tamale
2 lettuce
2 tomato
3 cherry
4 milk
4 soda

The table is sorted by group.

I am looking for a way to set a range dependent on the value in the
group column.
For example, I want to make set a range that includes the currentregion
for all of the group 1's. In the example it would include the three
rows that have 1 under group.

This will be followed on by creating another range for the 2's, then
the 3's and so on.

How can I do this?

TIA
 
HI papa,
Have you looked at Data, Subtotals

There is a picture at
http://www.mvps.org/dmcritchie/excel/sumdata.htm#subtotals
You can probably find something better at
http://www.contextures.com/excel/tips or in your Excel Help

by clicking on the + or - you can show different levels
and if you use the "Select only visible cells in the current selection"
icon (4 filled rectangles in a rectangle) or use ALT+; (semicolon)
to be able to format what you see to make then stand out in the
complete report.
Shortcut Keys in Excel 2000
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
 
Back
Top