This was one of the best videos I've ever watched. The time and consideration you put into your visuals to help the viewer better understand what you were saying (using blue arrows and orange arrows to differentiate between the occurrences or using a border around the range you were talking about) is great. Seriously man keep up the great work. Definitely subscribing to your channel.

Excellent video and well explained. Thank you!

@ExcelSmith

Жыл бұрын

Thank you. I'm glad it was helpful.

Very Helpful. Thanks

@ExcelSmith

2 жыл бұрын

Thank you. I'm glad it was helpful.

Thank u so much

@ExcelSmith

2 жыл бұрын

You're welcome. Thanks for the comment.

gooooood work

@ExcelSmith

2 жыл бұрын

Thank you.

What I was looking for-Thanks. How can I pull the results to another row showing what matched and how many times, so John & Guitar = 2, Stuart & Bass =2, etc. Thanks so much.

@ExcelSmith

Жыл бұрын

Thanks for the comment and the question. To count the number of unique name / instrument pairs, I would use the COUNTIFS function. Let's assume column A is the list of names, column B is the list of instruments, column D is the list of unique names, and column E is the list of unique instruments. To count how many instances of the combination of values in cells D2 and E2 exist in columns A and B (eg: John & Guitar), you could use this equation in cell F2: =COUNTIFS(A:A,D2,B:B,E2) I hope this helps.

Hi, I tried this but it gives error message =MATCH(A2&B2,$A$1:$A$9&$B$1:$B$9,0)ROW() * Could you please help? thanks

@ExcelSmith

Жыл бұрын

Thanks for the comment. I'd be happy to try and help. Can you please let me know what error you're receiving? Could you also tell me about the structure of your data?

Why once I highlight the duplicates, foes the filtering option completely freeze every time I click it after ughhhhh

@ExcelSmith

Жыл бұрын

Thanks for the question. I'd be happy to see if I can help resolve the issue. Would you be able to share a little bit more about the setup of your spreadsheet as well as the formula you've entered?

@ElRobin

9 ай бұрын

that was my problem, I was trying that method but it was incredibly painful when trying to filter after highlighting duplicates. The method in the video actually worked quite well.

Too long! Just make your every video straightforward without too many sentences and prologue. You can make such an explanation in just 5 to 7 minutes. Then I will subscribe to your channel.

@ExcelSmith

2 жыл бұрын

Thank you for the comment. That is helpful feedback as my goal is to continue to work to find that balance between problem statement, explanation, and solution to deliver the best content I can.