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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
525
_SGX_
S
H
  • Solved
Search for topics based on their groups.
Replies
7
Views
406
Peter_SSs
Peter_SSs
H
  • Solved
populate dynamic list in dropdown without duplicates items based on sheet name
Replies
3
Views
318
kevin9999
K
R
  • Question Question
Highlighting cells based on criteria
Replies
0
Views
443
rahildhody
R

Forum statistics

Threads
1,224,821
Messages
6,181,163
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