lisa

I am attempting to count the unique values in one column where a criteria is met in another column. (Assume the following data starts in cell A1.) I want to count the number of different Names in Office 1. (The answer is 3: Joe, Lisa and Betty.) I don't think the COUNTIFS function will work...

hi guys Data as follows <tbody> a b c d e 1 john amy 2 bob bob 3 tim keith 4 amy emma 5 becky lisa 6 keith john 7 george lisa 8 dan dan 9 lisa tim 10 emma becky </tbody> What I need is a formula (preferably, I don't like macro's!) in e that...

Hi, I am trying to obtain an average from multiple criteria using AVERAGEIFS function. The issue is I want to be able to specify the average range in a dynamic way based on column header name. I used index/match to specify the column name using header name for AVERAGEIF and it works like a...

Hello, I got two set of data that needs to be align by id. I need a formula/vba to go down two sets of number and insert a blank line if there's no match and go on to the next number. One set of data is a-d and the other is f-i. I was only able to find something that only insert blanks into 1...

Hello, I was wondering if there is a formula on excel to do what I am trying to do: Example: Lets say John and Lisa was entered into a draw, John has 10 tickets and Lisa has 5. <tbody> Name Ticket Entries Number John 10 1-10 Lisa 5 11-15 </tbody> So my excel would look like this except...