jimmy

Hello, In column B I have case numbers and some of them are duplicate. I need to have it find the last duplicate number (furthest down in the column) and have it return the corresponding name associated to that row in Column H. Example: If I put the formula in cell I2, number 14019509 would...

If I want to count how many days someone worked based off the name in column B and the Day of the Month in Column C what kind of formula would I need? <colgroup><col span="3"></colgroup><tbody> <colgroup><col span="3"></colgroup><tbody> A B C Ticket Number Name...

I have 2 columns of time stamps that track when a case owner changes hands and would like to pull the last time stamp when the case was closed (In Bold - column E) and subtract it from the time the case was opened (In Bold - column C). Is it possible to search the first time for case # 12806301...

Hi everyone, I'm struggling with a pivot issue. Let's say that I have a pivot with months in the rows, customers in the columns and amount sold in the values. Let's also say that I have a customer Jimmy who has bought every single month, and another customer called Jack that has not bought in...

I have a set of data Column A = Names , Jimmy, Jon etc Column B = Countries; Spain, Germany etc Column C = "Yes" of "No" Column D = Numbers: 1,2,3 etc In column E, I would like a formula where the if the row in column C = "Yes" it sums the previous 3 scores in column D, matching "Jimmy" in...

Hello I need some help with creating a formula for the below table. What I am trying to achieve is in the "required results" column A. The "Name" entries will always have "Name" preceding <tbody> required results Name Jimmy Name Jimmy -shoes -shoes Name Tom Name Tom-Balls...

Hello, I currently have a table with a couple thousand pieces of data. What I am trying to do is create a formula of some type to know all the corresponding dates to a certain person based on their status. <colgroup><col><col><col></colgroup><tbody> Name Status Last Modified John Doe...