Want to Add Duplicate Name's Amount in Different column specific cell.

[Srawat]

Hi,

Is it possible to add column "Figure" amount in column Final figure when see duplicate name and second duplicate name has Type =4 .

Thanks,

[liwagab]

I would suggest you use a summarize tool (probably count) to isolate [Names] that has a duplicate.

Then use a formula tool with If statement given condition that it is "type = 1" based on the summarize tool

[Emmanuel_G]

Hi @Srawat ,

Find attached an easy way to achieve to this result.

Let me know if it works as you want.