greg

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...

Hello, I'm trying to match cases from my lookup list to my master list below using multiple criteria, to get the output in column H. I am able to match the "Chris Dobbs" case in row 4 by concatenating last name and gender on each of the two lists. But i cant figure out how I would find...

Hi, new user here who's not bad at Excel, but doesn't have a lot of experience with arrays. My problem: Given a list of groups (in this example types of fruit) and membership in each group (names), I'd like to generate a rows where each person's group memberships are listed. <tbody> A B C D...

hi. I want to compare the data I have in two different columns, let's say column A and column B, which in Column A contains old data, while column B contains the latest data and has some data that is not in column A. <tbody> A B John Robert Tina Greg Greg Mike Ken Ken Avril John...

Hi I'd like to create a sumif formula that sums up data based on criteria in multiple columns, but not sure if this is possible? In the table below, I'd like to sum up the number of HOURS for Greg (a user) that are i) approved (column G) ii) billable (column H) iii) from the month of August...