May 12 2022 03:46 AM
this is just an example below of what i'm looking for. I would like to be able to highlight every other circuit along with the rows associated with it. I tried conditional formatting but i don't know the formula to do this. Is it possible? The circuit numbers are always changing, and actual file is very large.
A00100 | North | Khan | Assess | ETH1000-2338827 |
A00101 | South | Lopez | Replace | ETH1000-2338827 |
A00102 | Central | Cartier | Deliver | ETH1000-2338827 |
A00103 | South | Lopez | Deliver | ETH1000-2338827 |
A00104 | Northwest | Cartier | Deliver | ETH1000-2338827 |
A00105 | South | Lopez | Assess | ETH1000-2338827 |
A00106 | Central | Cartier | Assess | ETH1000-2338827 |
A00107 | South | Lopez | Replace | ETH1000-2338827 |
A00108 | Northwest | Burton | Deliver | ETH1000-2336622 |
A00109 | Central | Khan | Repair | ETH1000-2336622 |
A00110 | West | Burton | Replace | ETH1000-2336622 |
A00111 | South | Lopez | Deliver | ETH1000-2336622 |
A00112 | West | Burton | Assess | TH2000-23334456 |
A00113 | Central | Michner | Assess | TH2000-23334456 |
A00114 | Northwest | Khan | Replace | TH2000-23334456 |
A00115 | South | Lopez | Assess | TH2000-23334456 |
A00116 | West | Burton | Assess | TH2000-23334456 |
A00117 | Northwest | Burton | Assess | ETH1000-9987779 |
A00118 | Northwest | Cartier | Replace | ETH1000-9987779 |
A00119 | Southeast | Khan | Replace | ETH1000-9987779 |
A00120 | Central | Cartier | Repair | ETH1000-9987779 |
A00121 | Southeast | Khan | Replace | ETH1000-9987779 |
A00122 | Northwest | Khan | Assess | ETH1000-9987779 |
A00123 | South | Lopez | Replace | ETH1000-9987779 |
A00124 | Northwest | Michner | Replace | ETH1000-9987779 |
A00125 | South | Lopez | Assess | ETH1000-5558378 |
A00126 | Northwest | Burton | Deliver | ETH1000-5558378 |
A00127 | South | Lopez | Deliver | ETH1000-5558378 |
A00128 | West | Khan | Assess | ETH1000-5558378 |
A00129 | Northwest | Michner | Deliver | ETH1000-5558378 |
A00130 | Southwest | Cartier | Replace | ETH1000-5558378 |
A00131 | Northwest | Khan | Assess | ETH1000-5558378 |
A00132 | Northwest | Khan | Replace | ETH1000-4433443 |
A00133 | West | Khan | Assess | ETH1000-4433443 |
A00134 | West | Khan | Replace | ETH1000-4433443 |
A00135 | Northwest | Khan | Assess | ETH1000-4433443 |
A00136 | West | Khan | Replace | ETH1000-4433443 |
A00137 | Southeast | Cartier | Assess | ETH1000-4433443 |
A00138 | Northwest | Michner | Deliver | ETH1000-4433443 |
A00139 | South | Lopez | Assess | ETH1000-4433443 |
A00140 | Northwest | Michner | Replace | ETH1000-4433443 |
A00141 | West | Khan | Replace | ETH1000-4433443 |
A00142 | Northwest | Khan | Assess | ETH1000-4433443 |
A00143 | Northwest | Burton | Assess | ETH1000-4433443 |
May 12 2022 03:51 AM
Is the attached example similar to what you are looking for?
May 12 2022 04:47 AM
May 12 2022 06:28 AM
Maybe like in the attached file. The values from column E are copied in column H. Then duplicates are removed with Data -> Remove Duplicates.
Every other # is then selected in column I with this formula:
=IF(MOD(ROW(),2)=1,H1,"")
This is the rule for conditional formatting which compares the values in column E with the values in column I:
=ISNUMBER(MATCH($E1,$I$1:$I$6,0))
May 12 2022 07:24 AM