Just saved me hours of work. Thank you!

@RabiGurungXybernetics

6 ай бұрын

You're welcome!

This is one of the most useful short video I've seen.

@RabiGurungXybernetics

Жыл бұрын

Glad it was helpful!

Very easy and better than what I was using in terms of nesting formulas. Thanks

@RabiGurungXybernetics

Жыл бұрын

Glad it helped!

It will save my time for my monthly task

@RabiGurungXybernetics

3 ай бұрын

Glad it helped!

It will help my activity a lot. Thank u.

@RabiGurungXybernetics

Жыл бұрын

You're very welcome! I'm so glad to hear that my content will be helpful for your activity. Thanks for watching and for taking the time to leave a comment.

This is actually very useful. Thanks!

@RabiGurungXybernetics

Жыл бұрын

You're welcome! I'm glad that you found the video useful and that it provided value to you. If you have any other topics or questions you'd like me to cover in future videos, feel free to let me know. Thanks for taking the time to watch and comment, and have a great day!

Thanks man! You have saved me!

@RabiGurungXybernetics

6 ай бұрын

Glad I could help!

Tricks was so awesome.

@RabiGurungXybernetics

Жыл бұрын

Thanks.

Just do conditional formating and select unique values

My excel shows FILTER as an invalid function. Do you know why?

@GreyPentagon

2 ай бұрын

I think you probably just have an older version.

Awesome ❤

@RabiGurungXybernetics

Жыл бұрын

Thanks 🤗

Thanks

@RabiGurungXybernetics

11 ай бұрын

Welcome

After 1/5 an hour, I finally got some easy formula & easy to use😢

@RabiGurungXybernetics

6 ай бұрын

Glad to help out.

This is good. I will definitely use this. How do you combine lists that have similar list items and each list also has unique list items into one list without duplicates?

@RabiGurungXybernetics

11 ай бұрын

Good question. I would drop the NOT() function from the example in my video and surround the final function using a UNIQUE() function. The formula would look like this. =UNIQUE(FILTER(A2:A27,COUNTIF(B2:B19,A2:A27))) I hope that helps, let me know if you have further question(s).

Thank u

@RabiGurungXybernetics

10 ай бұрын

Welcome

=FILTER(,NOT(COUNTIF(,)))

How did you get formulae explanation when you are writing formulae ?

@RabiGurungXybernetics

Жыл бұрын

When you start typing a formula in a cell in Google Sheets, the application will provide you with formula suggestions based on what you've typed so far. Once you select a formula, you'll notice a tooltip that pops up, explaining the syntax of the formula and how to use its parameters. Additionally, if you click on the "fx" button next to the formula bar, a dialog box will appear that allows you to browse all the available formulas in Google Sheets. You can search for a specific formula or browse by category. Once you select a formula, you'll be able to read a detailed explanation of its syntax and usage. I hope this helps!

I dont like too much formula in my file, If I want to get the absentee, I'd just copy both columns into 1 single column and remove duplicates. but this is quite helpful as a template.

@RabiGurungXybernetics

Жыл бұрын

Wouldn't that give just give me a mixed of names in Attendee and Registered, but unique names only? This is the output I got following your recommendation. Claire Railey Gurung Hailey Rose Gurung Kara Owen Bridgett Curry Emil Patton Mario Rosario Mason Murillo Edison Brooks Odell Sheppard Justine Gardner Toni York Bettye Rhodes Isaias Vaughan Brad Marsh Mike Pugh Grant Galloway Corrine Zhang Barry Fischer Maricela Jacobson Toby Nicholson Darron Ewing Gerry Dillon Philip Townsend Olive Colon Maritza Alvarado Truman Rubio This should be the correct output (like in the video). Odell Sheppard Toni York Isaias Vaughan Mike Pugh Corrine Zhang Barry Fischer Darron Ewing Maritza Alvarado These are the steps I did. 1) Combine both names into one column. 2) Data ~ Data Tools ~ Remove Duplicates

@gerardodelrio3778

Жыл бұрын

@@RabiGurungXybernetics oh yeah, forgot about that. My usual step is Copy everything in one column > condition formatting > filter the duplicates > delete forgot about the function of remove duplicates that it only removes the duplicates and not remove both duplicate names. but I am currently using your formula as a template to check daily biometric logins.

Will it work on different languages?

@RabiGurungXybernetics

2 ай бұрын

This is a very interesting question. Do you have an example dataset?

Or conditionnal formatting..

@RabiGurungXybernetics

Жыл бұрын

Good suggestion bro. I made another video with Conditional Formatting and gave a shout out to you. Link below. kzread.infoGX-BYEgcnRA?feature=share Suggestion like these are the main arteries of my channel. Thanks for making that suggestion.

Can you please share the sheet for practice

@RabiGurungXybernetics

Жыл бұрын

I do not have any conduit to share the sheet at the moment.

It does not work at all. FIlter is no valid function.

@RabiGurungXybernetics

4 ай бұрын

What version of Excel do you have? You can find out by clicking on File ~ Account.

@heimatcz

4 ай бұрын

@@RabiGurungXybernetics 2016 MSO (16.0), 64 bit

@RabiGurungXybernetics

4 ай бұрын

Ah! Excel 2016 does not support FILTER() function. It was introduced in Microsoft 365 and Microsoft Excel 2021. Details in the link provided. I had also created a FILTER() function using VBA in my past KZread video. Link to that is below as well. I Created a FILTER() Function For Excel 2016 and Older Versions - Excel Tips and Tricks kzread.infoSQCGS5Ubblk?si=q8rntcbhrxjoMb9c support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

@heimatcz

4 ай бұрын

@@RabiGurungXybernetics Thank you for letting me know! :)

I used it but it didn't highlight the correct names. A lot of the names that appeared on the absentee list were in both registered and attendee columns. Really weird.

@RabiGurungXybernetics

5 ай бұрын

please send me your formula and I will have a look. Also when you send me your formula, please id the columns for Registered (original list) and Attended list.

@silviar5678

2 ай бұрын

I had the same issue

Can I use coulmns instead of lists

@RabiGurungXybernetics

9 ай бұрын

Sorry did not follow your question.

Does it work for row too?

@RabiGurungXybernetics

9 ай бұрын

Excellent suggestion. I will make a video to show you how to do that.

Does it work on Dates?

@RabiGurungXybernetics

9 ай бұрын

Yes it does. I gave you a shout-out in the video. Below is the link to the KZread Short for your question. Compare two columns of dates in Excel - Excel Tip and Tricks kzread.info2p4lx0YIgJ0?si=IU8ExjEn8TfaA3kW

Whats wrong with V/X lookup eith IF

@RabiGurungXybernetics

Жыл бұрын

Nothing wrong with using VLOOKUP. Totally doable. I'll create a video and upload it into my channel. We very much appreciate your constructive comments and suggestions.

I hate excel for the variations in formulas. You use comma's. Why do I have to use semicolons?

I couldn’t apply it effectively

@RabiGurungXybernetics

9 ай бұрын

Which part are you stuck at?

Can someone write down the formula?

@RabiGurungXybernetics

9 ай бұрын

Here is the formula. =FILTER(A2:A27,NOT(COUNTIF(B2:B19,A2:A27)))

@hasibulislamsalman2663

9 ай бұрын

@@RabiGurungXybernetics Thank you so much.

Vloolup karo na😡

There must be an easier way.

@RabiGurungXybernetics

10 ай бұрын

Well you are in luck my friend. Below is the complete list of all my KZread shorts for comparing two list. I'm confident one of this world work for you. How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick kzread.infopJtB8dbbimw?si=iL8qnDJ_WVAhKhAX Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks kzread.infonOwMXkZJ5HU?si=N80igNW7Vr-xCK5x Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks kzread.info1XGIPzsvS_Y?si=cu3ajNdT3lXFX3LB How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks kzread.infoGX-BYEgcnRA?si=16oLe6kcxZExM4Df How to compare two lists to find missing values in excel - Excel Tips and Tricks kzread.infodl75Lz_jaPs?si=-UTAvmCRdTl6ZZgm

@RabiGurungXybernetics

10 ай бұрын

Did any of the links I sent fit your requirement?

@alokkumar_Sai

4 ай бұрын

What if have more than 2 lists and have to find out missing value of list 1 from other lists?

Fantastic

@RabiGurungXybernetics

Жыл бұрын

Thank you from the bottom of my heart for your kind comment on my KZread video. Your support and enthusiasm motivate me to create even better content. I'm grateful to have you as part of my channel's community. Sending you my warmest thanks!