JODomingos
New Member
- Joined
- Jul 11, 2020
- Messages
- 48
- Office Version
- 2016
- Platform
- Windows
Hi Fellows.
I need a help to design a VBA macro for the following issue: I want to Unify rows 4 and 5 (SourceA), based on the condition:
When the cell B4 and B5 have "AA" ; "CC" ; "GG" ; "TT" then get the most frequent in the column of source A range and put into third cell below(Most frequent), make a loop for all cells right until the last column filled.
If B4 or B5 have anything different of "AA" ; "CC" ; "GG" ; "TT" then consider just the cell with the double letter.
Besides that i would like to perform that macro for many Sources in coluns A.
See in the picture the expected result.
Really Thank you in advance.
I need a help to design a VBA macro for the following issue: I want to Unify rows 4 and 5 (SourceA), based on the condition:
When the cell B4 and B5 have "AA" ; "CC" ; "GG" ; "TT" then get the most frequent in the column of source A range and put into third cell below(Most frequent), make a loop for all cells right until the last column filled.
If B4 or B5 have anything different of "AA" ; "CC" ; "GG" ; "TT" then consider just the cell with the double letter.
Besides that i would like to perform that macro for many Sources in coluns A.
See in the picture the expected result.
Really Thank you in advance.