User Profile

Danny_V

Copper Contributor

Joined 3 years ago

4 Posts

View All Badges

User Widgets

Recent Discussions

COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES
Good morning! I am trying to figure out how to take the three lines of the same person and info and combine them into one row but keep the "x" for each of the three shows so we can see who is going to each of the shows but not have three rows for each patron. Example: left is what we have, right is what I want it to look like after we combine them all. THANK YOU! SHOW 1 SHOW 2 SHOW 3 NAME ADDRESS PHONE EMAIL SHOW 1 SHOW 2 SHOW 3 NAME ADDRESS PHONE EMAIL X JOHN 123 STREET 555-5555 JOHN@JOHN X X X JOHN 123 STREET 555-5555 JOHN@JOHN X JOHN 123 STREET 555-5555 JOHN@JOHN X JOHN 123 STREET 555-5555 JOHN@JOHN
Solved
Jan 13, 2022 Place Excel
Excel
Formulas and Functions
Macros and VBA
office 365
1.6KViews
0likes
2Comments
Sort data if rank is found with RANK formula
Good morning, I have a project I am completing and the final step is to get the date shown in the sample file to sort based on the numbered rank under the "RANK" column that is populated using the =RANK formula. When I sort it, it messes up the formulas and this is a dynamic return of data that will change week to week. I need it to move to where the red arrow points based on the rank of the highlighted column that uses the RANK formula based on the percentage in W. Thank you for any assistance!
Solved
Jan 11, 2022 Place Excel
Formulas and Functions
877Views
0likes
2Comments

Groups

Recent Blog Articles

No content to show