How to insert unique Text on Summary Sheet

[PRADEEPB270]

Hi Good Morning

Please refer my attachment.

I want to insert Column C text unique on summary sheet.Namely-Summary F & O and Summary cash from their yellow tab colour sheet.

But unable to any idea.

For an example-Refer sheet summary-F&O,in this sheet column B unique text is taken from Sheet ICICI Direct-F&O.And the same taken in next combination of sheets-Summary Cah and ICICI Direct-Cash.

[HansV]

Does the attached version do what you want?

[PRADEEPB270]

It is not working when I insert a new code.

See the attachment.

[HansV]

Where exactly is the problem?

[PRADEEPB270]

the problem is appearing any other text on column C on the sheets i.e. ICICI Direct-F&O and ICICI Direct-Cash.

For an example,I am inserting a new company name.ie.TVSMOT on sheet ICICI Direct-cash ,but the formula is not working on sheet Summary-Cah.

[HansV]

Which version of Excel do you use? TVSMOD has been added to the Summary-Cash sheet on my PC with Microsoft 365:

S2515.png

[PRADEEPB270]

HansV sir,I have 2019 version of excel.I have sent my revised file which I am facing problem .

[PRADEEPB270]

The same problem exist again.

Refer my new attachment

[HansV]

The functions that I used require Microsoft 365 or Office 2021.
In the attached version, I have created formulas that should work in all versions.
If you edit them, confirm them with Ctrl+Shift+Enter.

Pradeep.xlsb

[PRADEEPB270]

Thanks Hansv,it is now ok and awesome formula that I know.

You are great SIR in this world.