tommy

EDIT: How do I attach an example workbook?? Hi, I have recently posted on a different Excel forum with no luck relating to my current issue. The workbook in question is a tracker of mixed-martial arts fights. The issue relates to tracking the current and past champions. I am trying to fill...

I'm in need of some code that will put the values in the cells of Column D into a comment of the associated name in Column B. I do not have room in the worksheet cells to put this info and thought including the information as a comment with the person's name might be a solution. Column D...

I need to write a formula that calculates a median value, with several IF clauses. EG 'data' tab is below: <tbody> Person Sales Margin Tommy 2 100 Jimmy 3 300 Henry 5 500 Jimmy 4 200 Jimmy 6 100 Tommy 10 200 Henry 3 700 Henry 5 1000 Tommy 7 500 </tbody> In another tab, I...

Needing assistance with the following... Name Month Rank Time Order # Desired Result Bobby April 4 2:30 12433 0 Bobby April 0 4:30 14655 1 Bobby April 4 7:30 18654 0 Bobby April 2 3:30 98752 0 Bobby April 0 1:30 11548 1 Tommy April 0...

I have an inventory of items in a sheet named Working Population. I would like to write some code that allows someone to select the names of the Associates that are in the office that day, then have Excel auto-enter those names into column E (the same process would happen in column J, but with...

I'm wanting to present the EU with a way to identify who referred a Client to them. If another Client did, then I want to track how many referrals that Client has sent the EU's way. Client's have the following identifiers: Name, Nickname and Client ID. All 3 are already named ranges and of...

I have what should be a simple task. I'm trying to concatenate some cells to complete a name. I didn't have an issue before I added the middle initial to the formula, but now I'm struggling. I've searched the forum, but only see concatenation examples for First and Last names, not anything...