tiger

Good day! I have dataset that looks like this (let's assume that "Name" is column A and "Sequence" is column B): <tbody> Name Sequence BUNNY 1 BUNNY 2 BUNNY 3 BUNNY 4 TIGER 1 TIGER 2 TIGER 3 TIGER - DOG 4 DOG 3 DOG 1 DOG 2 </tbody> I am in the need of a simple...

Hi, I am trying to create a table that summarises the number of times a name appears in a range (in this case an entire column, A:A) that has delimiter (in this case a forward slash) structured data and is filtered by the contents of an adjacent range (in this case an entire column, B:B, where...

Hi, I am trying to create a table that summarises the number of times a name appears in a range (in this case an entire column, A:A) that has delimiter (in this case a forward slash) structured data. Example dataset <tbody> Tiger Woods / Greg Norman Greg Norman Tiger Woods / Ernie Els...

so i have a cell contains text string and i want to extract out the string with the reference i have, i know we can use FIND or SEARCH but i only know to use it for a text string not a range of cell. So from column A, Reference data is D1:D3 to column B...

Can you do i count if off of a pivot table result, if so how? example of data below. I would want a count of each golfers name <colgroup><col></colgroup><tbody> G Jason Day G Adam Scott G Zach Johnson G Kevin Chappell G Francesco Molinari G Charley Hoffman G Rickie Fowler G Tiger Woods G...

I have a text string in say, A6 separated by semicolon, comprising of 8 words which looks something like this dog;cat;mouse;tiger;squirrel,moose,panther,lion I would like to extract the 4th, 5th and 8th word i.e. tiger, squirrel and lion in D6, E6 and F6 respectively. After extraction, D6...