Compare and find similar values present in column entire A

1 次查看（过去 30 天）
Santosh Biradar
Santosh Biradar 2022-7-21
编辑： Santosh Biradar 2022-7-21
Hello Everyone
In the SummaryResult Excel, (Attached) . It is having 2 sheets. MissingData and NewlyaddedData.
if 1st Sheet or/And 2nd Sheet, A3 having value aaa and A6 also having aaa (like the same values present in A Column only) then Entire ROW from those sheets will be written separately to new *AAA* Sheet in the Same SummaryResult.xlsx
if 1st Sheet or/And 2nd Sheet, A4 having value bbb and A5 also bbb (the same values present in A Column only)then entire ROW from those sheets will be written separately to new *BBB* sheet in the Same SummaryResult.xlsx
I have attached upated Required SummaryResult.xlxs
Please have a look for ref. Sheet AAA and BBB
Thank you

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by