excel vba to merge data base on criteria and countif with left function

P

phooirv

New Member
Joined
Feb 12, 2019
Messages
3
[TABLE="width: 656"]
<colgroup><col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="width: 96, bgcolor: #70AD47"]StartTime[/TD]
[TD="width: 62, bgcolor: #70AD47"]Code[/TD]
[TD="width: 86, bgcolor: #70AD47"]Location 1[/TD]
[TD="width: 77, bgcolor: #70AD47"]Location 2[/TD]
[TD="width: 75, bgcolor: #70AD47"]Location 3[/TD]
[TD="width: 75, bgcolor: #70AD47"]Location 4[/TD]
[TD="width: 72, bgcolor: #70AD47"]Location 5[/TD]
[TD="width: 64, bgcolor: transparent"]
[/TD]
[TD="width: 74, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]6:56 AM[/TD]
[TD="bgcolor: yellow"]PP-001[/TD]
[TD="bgcolor: yellow"]122254_1_0[/TD]
[TD="bgcolor: yellow"]120609_3_0[/TD]
[TD="bgcolor: yellow"]120759_0_0[/TD]
[TD="bgcolor: yellow"]120944_1_2[/TD]
[TD="bgcolor: yellow"]121218_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]7:29 AM[/TD]
[TD="bgcolor: yellow"]PP-001[/TD]
[TD="bgcolor: yellow"]122254_1_0[/TD]
[TD="bgcolor: yellow"]122514_2_0[/TD]
[TD="bgcolor: yellow"]122555_0_0[/TD]
[TD="bgcolor: yellow"]122633_0_0[/TD]
[TD="bgcolor: yellow"]122826_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: yellow"]Sheet1[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]9:35 AM[/TD]
[TD="bgcolor: yellow"]PP-002[/TD]
[TD="bgcolor: yellow"]124440_0_0[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: yellow"]125509_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11:30 AM[/TD]
[TD="bgcolor: transparent"]PP-003[/TD]
[TD="bgcolor: transparent"]130751_0_0[/TD]
[TD="bgcolor: transparent"]131148_2_0[/TD]
[TD="bgcolor: transparent"]131505_0_0[/TD]
[TD="bgcolor: transparent"]131640_2_1[/TD]
[TD="bgcolor: transparent"]131916_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1:12 PM[/TD]
[TD="bgcolor: transparent"]PP-003[/TD]
[TD="bgcolor: transparent"]132421_0_0[/TD]
[TD="bgcolor: transparent"]132722_5_0[/TD]
[TD="bgcolor: transparent"]132933_3_0[/TD]
[TD="bgcolor: transparent"]133142_1_0[/TD]
[TD="bgcolor: transparent"]133440_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #70AD47"]StartTime[/TD]
[TD="bgcolor: #70AD47"] [/TD]
[TD="bgcolor: #70AD47"]Location 3[/TD]
[TD="bgcolor: #70AD47"]Location 4[/TD]
[TD="bgcolor: #70AD47"]Location 5[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]11:56 AM[/TD]
[TD="bgcolor: yellow"]PP-002[/TD]
[TD="bgcolor: yellow"]123213_1_0[/TD]
[TD="bgcolor: yellow"]123448_0_0[/TD]
[TD="bgcolor: yellow"]123546_1_1[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]2:23 AM[/TD]
[TD="bgcolor: yellow"]PP-001[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: yellow"]124401_4_2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: yellow"]Sheet2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4:22 AM[/TD]
[TD="bgcolor: transparent"]PP-003[/TD]
[TD="bgcolor: transparent"]131308_2_0[/TD]
[TD="bgcolor: transparent"]131308_2_0[/TD]
[TD="bgcolor: transparent"]131308_2_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]11:30 AM[/TD]
[TD="bgcolor: yellow"]PP-001[/TD]
[TD="bgcolor: yellow"]133206_0_0[/TD]
[TD="bgcolor: yellow"]133206_0_0[/TD]
[TD="bgcolor: yellow"]133206_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1:12 PM[/TD]
[TD="bgcolor: transparent"]PP-004[/TD]
[TD="bgcolor: transparent"]135238_0_3[/TD]
[TD="bgcolor: transparent"]135405_0_0[/TD]
[TD="bgcolor: transparent"]135444_1_2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #70AD47"]StartTime[/TD]
[TD="bgcolor: #70AD47"] [/TD]
[TD="bgcolor: #70AD47"]Location 2[/TD]
[TD="bgcolor: #70AD47"]Location 3[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]3:13 AM[/TD]
[TD="bgcolor: yellow"]PP-001[/TD]
[TD="bgcolor: transparent"]125022_0_0[/TD]
[TD="bgcolor: transparent"]125043_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: yellow, align: right"]5:22 AM[/TD]
[TD="bgcolor: yellow"]PP-002[/TD]
[TD="bgcolor: transparent"]131940_0_0[/TD]
[TD="bgcolor: transparent"]132008_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: yellow"]Sheet3[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8:12 AM[/TD]
[TD="bgcolor: transparent"]PP-003[/TD]
[TD="bgcolor: transparent"]133949_0_0[/TD]
[TD="bgcolor: transparent"]133949_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #70AD47"]StartTime[/TD]
[TD="bgcolor: #70AD47"]Code[/TD]
[TD="bgcolor: #70AD47"]Location 1[/TD]
[TD="bgcolor: #70AD47"]Location 2[/TD]
[TD="bgcolor: #70AD47"]Location 3[/TD]
[TD="bgcolor: #70AD47"]Location 4[/TD]
[TD="bgcolor: #70AD47"]Location 5[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6:56 AM[/TD]
[TD="bgcolor: transparent"]PP-001[/TD]
[TD="bgcolor: transparent"]123254_1_0[/TD]
[TD="bgcolor: transparent"]120609_3_0[/TD]
[TD="bgcolor: transparent"]120759_0_0[/TD]
[TD="bgcolor: transparent"]120944_1_2[/TD]
[TD="bgcolor: transparent"]121218_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7:29 AM[/TD]
[TD="bgcolor: transparent"]PP-001[/TD]
[TD="bgcolor: transparent"]122254_1_0[/TD]
[TD="bgcolor: transparent"]122514_2_0[/TD]
[TD="bgcolor: transparent"]122555_0_0[/TD]
[TD="bgcolor: transparent"]122633_0_0[/TD]
[TD="bgcolor: transparent"]122826_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9:35 AM[/TD]
[TD="bgcolor: transparent"]PP-002[/TD]
[TD="bgcolor: transparent"]124440_0_0[/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"]125509_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11:56 AM[/TD]
[TD="bgcolor: transparent"]PP-002[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]123213_1_0[/TD]
[TD="bgcolor: transparent"]123448_0_0[/TD]
[TD="bgcolor: transparent"]123546_1_1[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: yellow"]Cosolidated[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2:23 AM[/TD]
[TD="bgcolor: transparent"]PP-001[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"]124401_4_2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11:30 AM[/TD]
[TD="bgcolor: transparent"]PP-001[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]133206_0_0[/TD]
[TD="bgcolor: transparent"]133206_0_0[/TD]
[TD="bgcolor: transparent"]133206_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3:13 AM[/TD]
[TD="bgcolor: transparent"]PP-001[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]125022_0_0[/TD]
[TD="bgcolor: transparent"]125043_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5:22 AM[/TD]
[TD="bgcolor: transparent"]PP-002[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]131940_0_0[/TD]
[TD="bgcolor: transparent"]132008_0_0[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 655"]
<tbody>[TR]
[TD="width: 116, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 874, bgcolor: transparent, colspan: 6"] How to Use VBA tp merge from Sheet 1, Sheet2 and Sheet 3 into 1 New Sheet (cosolidated) Only For Code PP-001 and PP-002
[/TD]
[/TR]
[TR]
[TD="width: 116, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 874, bgcolor: transparent, colspan: 6"] How to check Duplicate Record for Only selected the first 4 Character (For example 12514_2_0 and 12512_3_1 is consider Duplicate
[/TD]
[/TR]
[TR]
[TD="width: 116, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 116, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 614, bgcolor: transparent, colspan: 5"] I try ro use COUNTIF($C25:$G25;LEFT(C25,4))>1 But Not working
[/TD]
[/TR]
[TR]
[TD="width: 116, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 430, bgcolor: transparent, colspan: 4"] Countif(range,left(Text,4)>1 not working ???
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

J
  • Solved
How to aggregate data based on multiple criteria?
Replies
8
Views
1K
Jurez
J
S
  • Question Question
Excel Customer List to Word Offer and Invoice template, with unique invoice number list and buttons to create
Replies
0
Views
514
_SGX_
S
H
  • Solved
Search for topics based on their groups.
Replies
7
Views
398
Peter_SSs
Peter_SSs
H
  • Solved
populate dynamic list in dropdown without duplicates items based on sheet name
Replies
3
Views
316
kevin9999
K
R
  • Question Question
Highlighting cells based on criteria
Replies
0
Views
418
rahildhody
R

Forum statistics

Threads
1,223,896
Messages
6,175,260
Members
452,627
Latest member
KitkatToby

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