Excel. Marking variable rows based on fixed column values from other sheet

E

evilcreature

New Member
Joined
May 16, 2017
Messages
2
Dear Experts,

I have 2 excel files.
I need to fill the column A (Target), with Value in Column D (Remarks) of Target.xls where Column A(Style) and B (Size) of Target.xls Match with Column B (Style) and C (Size) in Source File, for the number of rows based on value in Column C (Total) in Target File.
I do not want to use VBA and codes. Please advise if it is possible using any combination of Lookup functions.

Source.xls
[TABLE="class: grid, width: 371"]
<tbody>[TR]
[TD]Target[/TD]
[TD]Style[/TD]
[TD]Size[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2235.1[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

Target.xls
[TABLE="class: grid, width: 293"]
<tbody>[TR]
[TD]Style[/TD]
[TD]Size[/TD]
[TD]Total[/TD]
[TD]Remark[/TD]
[/TR]
[TR]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.22.2338.0[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]5[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.22.2338.0[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.22.2338.0[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]10[/TD]
[TD]O-1/23[/TD]
[/TR]
[TR]
[TD]LCM.22.2338.0[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]5[/TD]
[TD]O-1/23[/TD]
[/TR]
</tbody>[/TABLE]

Source Result.xls
[TABLE="class: grid, width: 371"]
<tbody>[TR]
[TD]Target[/TD]
[TD]Style[/TD]
[TD]Size[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.11.2129.0[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.12.1576.01[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.12.1576.01[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.12.1576.01[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.12.2130.0[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2234.4[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2235.1[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O-1/23[/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LCM.21.2302.2[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]


Regards
 
Last edited by a moderator:

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

J
  • Question Question
Removing blank rows based on cell value
Replies
2
Views
304
Peter_SSs
Peter_SSs
S
  • Question Question
VBA code for adding new group of columns with 3 condictions from 2 dictionary and 1 array Then fill in data from value from original columns
Replies
1
Views
127
sijpie
sijpie
K
  • Question Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
607
awoohaw
awoohaw
S
  • Solved
Ranking with NET and with in the group
Replies
7
Views
109
sksanjeev786
S
M
  • Solved
Chose random % of row from sheet1 and paste in to sheet2
Replies
3
Views
253
motilulla
M

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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