avadhutd2
01-07-2010, 06:52 AM
Hi,
I need help in dentifying duplicate rows (may be more than one) in a worksheet. I tried searching data over the net for this, but need some specific help.
I had attached a sample worksheet with 5-6 rows, out of these 3 rows are identical.
I need to get a function going that will
1) identify the row & get the duplicate count.
2) neglect this row and go for next row for processing.
Can anyone guide me best possible way to get this done?
Thanks in advance...
Cheers!
I need help in dentifying duplicate rows (may be more than one) in a worksheet. I tried searching data over the net for this, but need some specific help.
I had attached a sample worksheet with 5-6 rows, out of these 3 rows are identical.
I need to get a function going that will
1) identify the row & get the duplicate count.
2) neglect this row and go for next row for processing.
Can anyone guide me best possible way to get this done?
Thanks in advance...
Cheers!