Plse Help To Reduce

  • Thread starter Thread starter Michael168
  • Start date Start date
M

Michael168

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
 
David said:
*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 said:
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. *
Click to expand...
Click to expand...

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
 
Back
Top