How to find series of missing numbers in a cell that has values separated by commas in excel

[Rajanigp]

Hello All,

I am trying to find all missing numbers in a cell that have values separated by commas if Column A has "E " in the text. I have below a screenshot of what the data looks like and what the expected results should be in Column C.

 

[bosco_yip]

Cross post : How to find series of missing numbers in a cell that has values separated by commas in excel - Stack Overflow

 

[vletm]

Rajanigp
As a new member, You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

eg there are few sentences about cross-posting.