Excel Partial Cell Match [Closed]

Report
-
Hello,

I am doing a report of online tracking with automatic data generator

raw data output format

tracking ID / Views / Visit
A_B_C_DEFG_H_I / 8 / 2
A_B_C_DEFG_H_I / 7 / 4
A_B_C_DEFG_H_I / 8 / 2
A_Z_W_DEFG_K_O / 6 / 3
A_Q_W_FFFF_O_E / 8 / 3

How can I summarize the views and visits with the unique key "DEFG"only (Partial cell match)?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!