complex condition

L

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi

The main file is uploaded - please see the link below. I have this condition, if material number of line C is 1000015445 and material number of line H is 1000027024 OR 1000027025 then these 2 can not have the same week#. I want excel to flag or highlight or give warning etc in that condition is met. Any help would be very much appreciated.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]line c[/TD]
[TD]line h[/TD]
[TD]week[/TD]
[/TR]
[TR]
[TD]material number[/TD]
[TD]1000015445[/TD]
[TD]1000027024 OR 1000027025[/TD]
[TD]Can not be same week - excel should give flag[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1000015448[/TD]
[TD]same above[/TD]
[TD]same above[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2000012082[/TD]
[TD]same above[/TD]
[TD]same above[/TD]
[/TR]
</tbody>[/TABLE]

https://drive.google.com/file/d/1QNnoHhWtmQxKkCa5bc6vCRKO5kirLXVt/view?usp=sharing

sample of the file is here

[TABLE="class: grid, width: 280"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Line[/TD]
[TD]Material Number[/TD]
[TD]WK[/TD]
[TD]Gas rate[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035858[/TD]
[TD]36[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035840[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000016097[/TD]
[TD]38[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015453[/TD]
[TD]38[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000025275[/TD]
[TD]38[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035840[/TD]
[TD]38[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2000014493[/TD]
[TD]40[/TD]
[TD]A-85[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000027531[/TD]
[TD]40[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015448[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015445[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015453[/TD]
[TD]42[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035858[/TD]
[TD]42[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015852[/TD]
[TD]42[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000016097[/TD]
[TD]42[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000030063[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000025465[/TD]
[TD]43[/TD]
[TD]A-70[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000025441[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000016095[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000028049[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000016057-010[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035056[/TD]
[TD]43[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035050[/TD]
[TD]44[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015549-010[/TD]
[TD]44[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000029645[/TD]
[TD]44[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000027284[/TD]
[TD]45[/TD]
[TD]A-31[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015448[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015445[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035840[/TD]
[TD]47[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015455[/TD]
[TD]47[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000025275[/TD]
[TD]48[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015448[/TD]
[TD]49[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000015445[/TD]
[TD]49[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2000014294[/TD]
[TD]53[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1000035055[/TD]
[TD]54[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]2000012131[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1000026304[/TD]
[TD]44[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1000026304[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1000026304[/TD]
[TD]46[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1000038202[/TD]
[TD]47[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]1000037593[/TD]
[TD]37[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]1000027375[/TD]
[TD]38[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]1000024663[/TD]
[TD]43[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]1000016018[/TD]
[TD]53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000028547[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000028626[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000029533[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000025015[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000029002[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000015744[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000036376[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000036873[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000036859[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000028268[/TD]
[TD]37[/TD]
[TD]A-46[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000027024[/TD]
[TD]38[/TD]
[TD]DME[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]1000027025[/TD]
[TD]39[/TD]
[TD]DME[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Using your example above, which rows meets the criteria?
 
Upvote 0
Thanks for your reply. In The table above that I paste

1) Line 10 and Line 11 (wrong, both are used in the same week)
2) Line 27 and 28 (same above)
3) Line 32 and 33 (same above)

In the excel sheet

1) Line 12 and Line 13 (wrong, both are used in the same week)
2) Line 29 and 30 (same above)
3) Line 34 and 35 (same above)
Thank you.
 
Last edited:
Upvote 0
if material number of line C is 1000015445 and material number of line H is 1000027024 OR 1000027025 then these 2 can not have the same week#.
Click to expand...

I don't quite understand what you mean.
I thought you want to check if line C & line H has the same week in those particular number.
But the result of your example don't have anything to do with line H.
What you show is:
if line C is 1000015445 or 1000015448 has the same week then it's should be marked.
 
Upvote 0
I am so sorry, you are right. Ignore my second explanation please. you explained it better. Thank you.

Akuini said:
I don't quite understand what you mean.
I thought you want to check if line C & line H has the same week in those particular number.
But the result of your example don't have anything to do with line H.
What you show is:
if line C is 1000015445 or 1000015448 has the same week then it's should be marked.
Click to expand...
 
Upvote 0
Using your example, I couldn't find the rows that meets the criteria. So I change the data to show how it works.
The criteria is:
If line C with material number 1000015445, 1000027024 or 1000027025 has the same week with line H with material number 1000015448 or 2000012082 then rows should be marked.

The code use col F to mark the rows. It is marked with row number of the other row that make them meet the critea.

Code: 
[B][color=Royalblue]Sub[/color][/B] a1076363a()
[i][color=seagreen]'https://www.mrexcel.com/forum/excel-questions/1076363-complex-condition.html[/color][/i]

va  = Range([color=brown]"A1:C"[/color] & Cells(Rows.count,  [color=brown]"A"[/color]).[B][color=Royalblue]End[/color][/B](xlUp).row)
[B][color=Royalblue]ReDim[/color][/B]  vc([color=crimson]1[/color] [B][color=Royalblue]To[/color][/B]  UBound(va, [color=crimson]1[/color]), [color=crimson]1[/color]  [B][color=Royalblue]To[/color][/B] [color=crimson]2[/color])
[B][color=Royalblue]ReDim[/color][/B]  vh([color=crimson]1[/color] [B][color=Royalblue]To[/color][/B]  UBound(va, [color=crimson]1[/color]), [color=crimson]1[/color]  [B][color=Royalblue]To[/color][/B] [color=crimson]2[/color])
[B][color=Royalblue]ReDim[/color][/B]  vz([color=crimson]1[/color] [B][color=Royalblue]To[/color][/B]  UBound(va, [color=crimson]1[/color]), [color=crimson]1[/color]  [B][color=Royalblue]To[/color][/B] [color=crimson]1[/color])
[B][color=Royalblue]For[/color][/B]  i = [color=crimson]4[/color] [B][color=Royalblue]To[/color][/B]  UBound(va, [color=crimson]1[/color])
     [B][color=Royalblue]If[/color][/B] va(i, [color=crimson]1[/color]) =  [color=brown]"C"[/color] [B][color=Royalblue]Then[/color][/B]
         [B][color=Royalblue]If[/color][/B] va(i, [color=crimson]2[/color]) =  [color=brown]"1000015445"[/color] [B][color=Royalblue]Or[/color][/B]  va(i, [color=crimson]2[/color]) = [color=brown]"1000015448"[/color]  [B][color=Royalblue]Or[/color][/B] va(i, [color=crimson]2[/color]) =  [color=brown]"2000012082"[/color] [B][color=Royalblue]Then[/color][/B]
        vc(i, [color=crimson]1[/color]) = va(i, [color=crimson]2[/color])
        vc(i, [color=crimson]2[/color]) = va(i, [color=crimson]3[/color])
        [B][color=Royalblue]End[/color][/B] [B][color=Royalblue]If[/color][/B]
    [B][color=Royalblue]End[/color][/B] [B][color=Royalblue]If[/color][/B]
    
     [B][color=Royalblue]If[/color][/B] va(i, [color=crimson]1[/color]) =  [color=brown]"H"[/color] [B][color=Royalblue]Then[/color][/B]
         [B][color=Royalblue]If[/color][/B] va(i, [color=crimson]2[/color]) =  [color=brown]"1000027024"[/color] [B][color=Royalblue]Or[/color][/B]  va(i, [color=crimson]2[/color]) = [color=brown]"1000027025"[/color]  [B][color=Royalblue]Then[/color][/B]
        vh(i, [color=crimson]1[/color]) = va(i, [color=crimson]2[/color])
        vh(i, [color=crimson]2[/color]) = va(i, [color=crimson]3[/color])
        [B][color=Royalblue]End[/color][/B] [B][color=Royalblue]If[/color][/B]
    [B][color=Royalblue]End[/color][/B] [B][color=Royalblue]If[/color][/B]

[B][color=Royalblue]Next[/color][/B]

[B][color=Royalblue]For[/color][/B]  i = [color=crimson]4[/color] [B][color=Royalblue]To[/color][/B]  UBound(vc, [color=crimson]1[/color])
     [B][color=Royalblue]For[/color][/B] j = [color=crimson]4[/color]  [B][color=Royalblue]To[/color][/B] UBound(vh, [color=crimson]1[/color])
         [B][color=Royalblue]If[/color][/B] vc(i, [color=crimson]2[/color])  <> [color=brown]""[/color] [B][color=Royalblue]And[/color][/B]  vh(j, [color=crimson]2[/color]) <> [color=brown]""[/color]  [B][color=Royalblue]And[/color][/B] vc(i, [color=crimson]2[/color]) =  vh(j, [color=crimson]2[/color]) [B][color=Royalblue]Then[/color][/B]
            vz(i, [color=crimson]1[/color]) = vz(i, [color=crimson]1[/color]) & j & [color=brown]";"[/color]
            vz(j, [color=crimson]1[/color]) = vz(j, [color=crimson]1[/color]) & i & [color=brown]";"[/color]
        [B][color=Royalblue]End[/color][/B] [B][color=Royalblue]If[/color][/B]
    [B][color=Royalblue]Next[/color][/B]
[B][color=Royalblue]Next[/color][/B]

Range([color=brown]"F1"[/color]).Resize(UBound(vz, [color=crimson]1[/color]), [color=crimson]1[/color]) = vz
[B][color=Royalblue]End[/color][/B] [B][color=Royalblue]Sub[/color][/B]



RESULT

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#008B8B][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
1​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
2​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
3​
[/td][td=bgcolor:#F8CBAC]
Line​
[/td][td=bgcolor:#F8CBAC]
Material Number​
[/td][td=bgcolor:#F8CBAC]
WK​
[/td][td=bgcolor:#F8CBAC]
Gas rate​
[/td][td=bgcolor:#F8CBAC]
​
[/td][td=bgcolor:#F8CBAC]
​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
4​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000035858[/td][td=bgcolor:#DEEBF6]
36​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
5​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000027531[/td][td=bgcolor:#DEEBF6]
40​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
6​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000015448[/td][td=bgcolor:#DEEBF6]
40​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]20;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
7​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000015445[/td][td=bgcolor:#DEEBF6]
40​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]20;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
8​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000015453[/td][td=bgcolor:#DEEBF6]
42​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
9​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000035056[/td][td=bgcolor:#DEEBF6]
43​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
10​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000015448[/td][td=bgcolor:#DEEBF6]
45​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]18;23;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
11​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000015445[/td][td=bgcolor:#DEEBF6]
45​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]18;23;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
12​
[/td][td=bgcolor:#DEEBF6]C[/td][td=bgcolor:#DEEBF6]1000035840[/td][td=bgcolor:#DEEBF6]
47​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
13​
[/td][td=bgcolor:#DEEBF6]G[/td][td=bgcolor:#DEEBF6]1000024663[/td][td=bgcolor:#DEEBF6]
43​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
14​
[/td][td=bgcolor:#DEEBF6]G[/td][td=bgcolor:#DEEBF6]1000016018[/td][td=bgcolor:#DEEBF6]
53​
[/td][td=bgcolor:#DEEBF6]
​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
15​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027025[/td][td=bgcolor:#DEEBF6]
35​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
16​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000028626[/td][td=bgcolor:#DEEBF6]
37​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
17​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000029002[/td][td=bgcolor:#DEEBF6]
37​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
18​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027025[/td][td=bgcolor:#DEEBF6]
45​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]10;11;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
19​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000036376[/td][td=bgcolor:#DEEBF6]
37​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
20​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027025[/td][td=bgcolor:#DEEBF6]
40​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]6;7;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
21​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000036859[/td][td=bgcolor:#DEEBF6]
37​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
22​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027024[/td][td=bgcolor:#DEEBF6]
42​
[/td][td=bgcolor:#DEEBF6]
A-46​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
23​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027024[/td][td=bgcolor:#DEEBF6]
45​
[/td][td=bgcolor:#DEEBF6]
DME​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00]10;11;[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#008B8B]
24​
[/td][td=bgcolor:#DEEBF6]H[/td][td=bgcolor:#DEEBF6]1000027025[/td][td=bgcolor:#DEEBF6]
39​
[/td][td=bgcolor:#DEEBF6]
DME​
[/td][td=bgcolor:#DEEBF6][/td][td=bgcolor:#FFFF00][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet2[/td][/tr][/table]
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
VBA: delete all rows where value (time) is less than 1 minute
2
Replies
13
Views
219
RobP
R
L
  • Solved
Count number of cells upward, where price is lower than current cell
Replies
2
Views
213
shaowu459
shaowu459
A
  • Solved
Two-value combination extraction formula?
2
Replies
11
Views
188
bebo021999
B
Z
  • Question Question
Xlookup with multiple conditions
Replies
5
Views
252
Cubist
Cubist
J
  • Question Question
Removing blank rows based on cell value
Replies
2
Views
256
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,893
Messages
6,175,239
Members
452,621
Latest member
Laura_PinksBTHFT

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top