Hi
in my excel data having column A
I want to extract the 2times and 3 times repeated value result to column B & C
check the value starts with "via at xy (xxxxx)" search in entire column A ,
in which 2 times repeated value copy to column B and 3 times repeated value copy to column c
result should be in with bracket (xxxxx) only, not come with via at xy
excel sheet
Bookmarks