Excel Partial Cell Match

Closed
Eric - May 6, 2015 at 04:37 AM
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)?