ryan

hi guys a i am trying to count the number of customers that have both product AR and SR and what is the combined QTY so for example i want something like this Product combo combined qty number of customer AR&SR 67 2 below is the...

I want to Sum values from Column A based on a specific Value in Column B. In the sample below I would want the total for each name based on values in Column A. For Example, John would = 15 total, Ryan = 7, etc. <tbody> # 12 John 5 Ryan 7 Mike 3 John 2 Ryan 5 Mike...

I am trying to look at my employee time sheets broken down by date, time, and who was on at the time. My time sheet software give me their clock in and clock out time. I've used MROUND to get the closest hour, now I'm struggling to put those names in the correct time slots. This is the data I've...

This is probably very simple for most people but I want to have a total number of names from a list but if the name comes up more than once I only want to count it once. For example: <tbody> <tbody> A 1 Ryan 2 Bob 3 Jim 4 Dan 5 Andy 6 Luke 7 Peter 8 Ryan 9 Andy 10...

Hi, I have a column with a line of text and then the next column has the exact same text but with additional info. I want to try and break them up so that I can just have the extra words. In the below example I want to try and have a formula in column C that would cut out "hi my name is' or...

Hi, I have a table that I am unable to change however I need to make the table set up in a way that I can use to enter into Power BI. On one sheet I have the months going across the top and I need to make a formula to bring the months amount into rows. I also need them to match two criteria...