Forum Discussion
Search and organize by row and keyword
Good morning everyone, I hope you are safe and healthy amid this crisis. I am trying to consolidate and organize a very large Excel file of contacts. Could you please tell me how I can grou...
Thank you. I did that and unfortunately, I still saw numerous duplications of names, etc.
Asked in a different way, is there a way to filter rows based upon a keyword in one of the columns of the row? For instance, if row 2, column b has "Zimmer" in it and row 300, column F has "Zimmer" can we bring those two rows up together and any others like it so I can easily see what should be removed and what needs to be consolidated together?
Thanks again!
Stephen
Unfortunately, this function would only consider duplicates in the same column(s). The only other way I can think that might work would be a conditional format - see example attached (enter the search word in cell F1).