carl

Hi there, I am looking to create a sumif (or sumifs) for the following data set, so that a sum is given for each name, HOWEVER with the caveat of the addioanl criteria of under a certain value. For example, the total sum of volume for Matt, but only for values less than 4. Please can someone...

Trying to find a way to get info from a data set into a list where by the list is populated only if a there is a figure next to a name for example: Data Set: Sue 0 Mark 16.99 Dave 0 Adam 0 Carl 2.45 Oliver 18.19 Kirsty 0 Which will populate a table...

The question is of reverse concatenation in Excel VBA. I currently have this: <tbody> Joe, Jon Joe, Pam, Carl Joe, Jon, Jeremy </tbody> And need to reverse concatenate so I can then have each individual name in its own row and cell as follows: <tbody> Joe Jon Joe Pam Carl...

I'm losing my mind on something that I feel should be quite easy. I'm trying to convert data from 1:Many, such as the attached sample image. For example, lets say I have data like this: <tbody> Person Item Bob Bananas, Apples Carl Oranges, Kiwi, Chocolate </tbody>...

I need help with a formula to count unique values in one column that match data in another column but using a wildcard. Column A has multiple names repeated in sequence and column B has data for every occurrence of a name. I want to be able to count the number of names that have Text in a cell...