I have also read there are issues with recording a macro when trying to find duplicates using more than one column in the formula, but I have not gotten that far so I can't test it.Īs is likely evident in my formula and process, I am not very experienced with Excel. That is as far as I have gotten, and I still do not know how to go about deleting the duplicate entries. Then I select the format as light orange text, but it is only highlighting A2. I am highlighting cell A2, and under Conditional Formatting, I select "Formula Is" =SUM(COUNTIF($G:$G,G2),COUNTIF($V:$V,G2))>1 Here are the tutorials I am looking at, but whatever I am doing is not working the way it is working for them. I also want to record a macro of this process to apply to all spreadsheets. I am trying to tell the spreadsheet that if column G *and* column V are both identical to another row's column G and V, then the entire row is a duplicate and to highlight and delete it.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |