Reply With", 10:47 PM #2, hi vijaysram.
Excel is a ars nova episode 5 sub indo handy tool for data manipulations and comparison of multiple data sources.
Last edited by JeffreyWeir; at 11:40.
Thanks for the challenge, and let me know if you have any questions or issues.Rows(lrow 1).Delete, else lrow lrow 1 End If Loop Note Thanks to rizvisa1 for this tip on the forum.Also, it may be have a option to compare to 6 columns and 8 columns in future.If lngRange Mod 2 0 Then varItems ems Else varItems ems End If lue anspose(varItems) 'Cleanup Set dic1 Nothing Set dic2 Nothing End Sub Reply With", 06:36 PM #8 Hi Jeffrey Thank you so much for your time and effort on this :-) I have.Reason: Added code tags.Like Column A will have numbers from range 1 to 2500 and column B will have numbers from range 20 to 2500 and Column C will have numbers from range 230 to 2500 and column D will have numbers from range 40 to 2500.
I have searched it in multiple websites but i couldn't find.Reply With", 01:54 PM #5 Originally Posted by JeffreyWeir Quick question: Are the items likely to be unique within a column?Issue, i have two columns A and.There is a straightforward way to do this with formulas.Hi All the 4 columns will have similar type of data.Once the criteria specified by the user matches the relevant cells, the can either be highlighted or deleted as per the need of the user in this office software.I'll code something up that allows you to select any number of ranges, so that you're all set for the future.Note that iterating through a long list psp memory stick games using this code would take quite a bit of time, and that there are a few other approaches that will be much more efficient.Related Published by aakai1056.If column A row 1 matches column B row 1 and if column E row 1 matches column 2 row 2 then move to row 2 and check if column A row 2 matches column A row 2 if this matches check to see.