Index Match Count

[philb99]

Hi - I had some great code from Mrmmickle1 but I would like further code please

I have put my Drop Box Link

https://www.dropbox.com/s/prmdf2unq4fy5je/dropbox2.xlsx?dl=0

Col E tells me if a case has been received

I have created in Col G, with coded help, all the Case Numbers where No Case - What I would like please in Col J details the Customer Number from Col B Linked directly to the No Case Number in Col G.

The I can report No Case and Customer Number

My spreadsheet could run to 20000+ lines

Thanks

 

[philb99]

excellent -thanks again for your help - works a treat