Under the tab Kutools, find the group Editing, click Select > Select Duplicate & Unique Cells.
In the pop-up dialogue box,:
1. Click the range-select button (targeted with a red arrow) to select the row you mentioned.
2. Under the Based on section, select Single cell.
3. Under the Rule and Processing of results sections, select the options you need.
4. Click OK. The duplicates will be then selected and displayed in the way you set.
Please help me to solve my challenge:(
I have a problem with a large table when i want to create summary of this table as below:
1- my table has some cells merged, therefor i can't make pivot table.
2- in each rows number containing between 7 to 11 rows but the row number cells are merged in column A, this means I have with each rows numbers more than one rows right side of that.
3- What I need in new table is, getting data's from the main table with minimum values in their price column "J" and if there are more than one item with the same price between some vendors, i also need to add them in new table but with the same rows number just added with index at the end of each row numbers like this: 101-->101a
I uploaded my excel data sheet with this request.
It will be my pleasure if anyone helps me with a VBA code.
Thanks and regards.