Hello to all
I have an excel file which contains account # and Disp columns,
Basically, Account # will have duplicate Values,
1. if it contains duplicates value then i need to check Disp column, if it contains values like "Full" and "Partial" then, leave full and cut "partial" row and move to another sheet.
2. If all duplicate rows for a account number is "Partial", then leave first row, then cut and paste remaining rows to another sheet (I mean duplicates)
Can we do it in Excel macros. i have attached sample file for reference.
I have an excel file which contains account # and Disp columns,
Basically, Account # will have duplicate Values,
1. if it contains duplicates value then i need to check Disp column, if it contains values like "Full" and "Partial" then, leave full and cut "partial" row and move to another sheet.
2. If all duplicate rows for a account number is "Partial", then leave first row, then cut and paste remaining rows to another sheet (I mean duplicates)
Can we do it in Excel macros. i have attached sample file for reference.