How to reduce the rows of data when 5 out of 6 cells are equal in the
range.

I have a worksheet with 28 rows. Each row have 6 columns (A:F)
So the range is A1:F28

Each cell contains a value. Each row has 6 unique value within the
row.

Thank yo



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

I don't understand this question either. Are you trying to remove
duplicates? In which case you might want to use a Filter.

How do you want to reduce. Please provide a text example of what
you have and what you want.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Michael168" wrote in message ...
How to reduce the rows of data when 5 out of 6 cells are equal in the
range.

I have a worksheet with 28 rows. Each row have 6 columns (A:F)
So the range is A1:F28

Each cell contains a value. Each row has 6 unique value within the
row.

David McRitchie wrote:
*I don't understand this question either. Are you trying to remove
duplicates? In which case you might want to use a Filter.

How do you want to reduce. Please provide a text example of what
you have and what you want.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Michael168" wrote in
message ...
How to reduce the rows of data when 5 out of 6 cells are equal in
the
range.

I have a worksheet with 28 rows. Each row have 6 columns (A:F)
So the range is A1:F28

Each cell contains a value. Each row has 6 unique value within the
row. *

Hello David,
Plse refer to sample data for info.
Sun Mon Tue Wed Pub Thu
Sun Mon Tue Pub Thu Fri
Mon Tue Wed Pub Thu Fri
Sun Mon Tue Pub Thu Sat
Mon Tue Wed Pub Thu Sat
Sun Mon Wed Pub Fri Sat
Sun Mon Tue Thu Fri Sat
Mon Tue Wed Thu Fri Sat
Mon Tue Pub Thu Fri Sat
Tue Wed Pub Thu Fri Sat
Sun Mon Tue Wed Pub Fri
Sun Mon Wed Pub Thu Fri
Sun Mon Tue Wed Pub Sat
Sun Mon Wed Pub Thu Sat
Sun Mon Tue Wed Fri Sat
Sun Tue Wed Pub Fri Sat
Sun Mon Wed Thu Fri Sat
Sun Mon Pub Thu Fri Sat
Sun Wed Pub Thu Fri Sat
Sun Mon Tue Wed Thu Fri
Sun Tue Wed Pub Thu Fri
Sun Mon Tue Wed Thu Sat
Sun Tue Wed Pub Thu Sat
Sun Mon Tue Pub Fri Sat
Mon Tue Wed Pub Fri Sat
Sun Tue Wed Thu Fri Sat
Sun Tue Pub Thu Fri Sat
Mon Wed Pub Thu Fri Sat

What I want to reduce is that when 5 or more dates in one row is find
in another row in the range then I want to reduce/hide the row. This
will check through the whole against one another.

May be I need some code to perform the task.

Thank you
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/