Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a range of rows having the same value in one column
Right now I'm looping through the sorted column and marking the
beginning row and end row of a column having a specific value and selecting that. But does Excel have a mechanism that does this for you? Or perhaps, instead of selecting the rows, selects all the values in one column having a specific value? Even better yet would be a solution where the rows can then be deleted. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a range of rows having the same value in one column
how about sorting or datafilterautofilter
-- Don Guillett SalesAid Software wrote in message ups.com... Right now I'm looping through the sorted column and marking the beginning row and end row of a column having a specific value and selecting that. But does Excel have a mechanism that does this for you? Or perhaps, instead of selecting the rows, selects all the values in one column having a specific value? Even better yet would be a solution where the rows can then be deleted. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a range of rows having the same value in one column
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a range of rows having the same value in one column
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a range of rows having the same value in one column
Thanks Guys.
Both tips were very helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Define Range in Deleting Empty Rows | Excel Programming | |||
define end column in a range | Excel Programming |