kim

Hi - I have data that represents classes assigned to a room. Some classes are two days a week, some classes are 1 day a week. I would like to have a visual of the room utilization and open slots. I tried a pivot table with class start and stop time as a row and Class Day as a column. That...

I'm stuck on what I think is a simple issue and can’t seem to figure out what is needed – any help is appreciated! I am looking to take a vertical list of data and pivot only two columns into stretching across the row, while keeping only one line for each unique Customer ID. My list has about...

I would like to be able to count based on these two conditions... I have a portfolio project named "Kim" and there are multiple subprojects under this portfolio with a priority assigned (numerical values used 1, 2, 3...etc) so I want to count how many projects are prioritized as a 1 for "Kim"...

Hi, I am looking for formula that can split contact name properly. I have 1,000+ Contact names like below.. Jennifer Monroe Monroe, Jennifer Ali Talai Talai, Ali Kim Millman Millman, Kim Stephen E Wood Wood, Stephen E In above example person name is repeated 2 times with ",". Now I want...

Dear All Please help me in this scenario. I have a master data sheet. Sample as below. <tbody> A B C D 1 Input Date 20/01/2018 2 Sr.No. Emp. Name Gate1 Gate2 3 1 Thomas 20/01/2018 01/02/2018 4 2 Bobby` 10/03/2018 20/01/2018 5 3 Kim 20/01/2018 20/01/2018 </tbody> Column...