Or, (and this maybe not related to what you are explaining) if your sheet contains emails with names you could just select the email column and then: Data > DataCleanup > Remove Duplicates . That method worked well for my needs however I don't believe it will work with multiple columns in the case of names which could be a problem if no other identifying columns exist.
Hi, I want to ask something. I have a column with numbers (let's say A1:A1000) and I want when I enter a number in this column that is the same with another one in this column, a warning message to pop up. I have used Data validation and the =COUNTIF($A10:$A1009,A10:A1009)
Hi, is there a way to separately list duplicates from a table? For example I have a table A1:C5 and the value on A2 and B5 are the same, it will show on A10. Thanks! I need it badly on my project.
Can anyone guide me that how to pull data from other sheet according the different codes. Look I have different accounts with the some codes right i want those all accounts in other sheet according to the codes.
No matter what I do, I simply cannot get this to work on my spreadsheet... I'm trying to apply this to my cold call spreadsheet to prevent me from calling people more than once, but it just won't flippin' work!
Speak of the devil. The moment I make that comment, it suddenly works. I am glad we have smart people like you making videos on Excel, because I'd have NEVER figured that out!
i believe we should learn or know the basic idea or logic behind how a car works to drive it in order to not to get lost anywhere haha, considering this i saw you have misplaced or less used $ in between both formulas. for example, you have used $ only one in the second formula whereas you used multiple time in the first one
Thank you for noticing Syed. I believe, in this case, the $ were purposely placed as they were so that that the range expands as you drag it down. For example, A$2:A2 becomes A$2:A3 which would then mean that the formula is looking at A2 and A3 when it's in row three. That dollar sign was meant to only fix the row and not the column. It would probably work if you made it $A2, but I found it more readable to put the $ only where it was needed.
Just apply the same technique but to the range that you want to use, such as the entire sheet with something like A1:Z1000 if that's the size of your data.
@@ProlificOaktree yes. it is. can you write it down here please or make video on it as no video is available to search data from entire sheet. please make a video and share the link here.