Find first instance, offset and mark

Alphacsulb

Alphacsulb

Active Member
Joined
Mar 20, 2008
Messages
414
Hi Excel World,

I'm hoping there is a way to automate my process through VBA, or maybe even a formula with the use of helper columns.


I'm primarily concerned with Column C and J and M.
Column C represents a zip code sort for mailing.
Column J represents a consecutive number.
Column M is a list of the unique cells in Column C.

Essentially whenever I find the first instance of the unique cell in C, I want column J to be overwritten with the number 1.

Here is my sample data:
Sheet1

*CDEFGHIJKLM
*************************SNGLPT38**
*************************SNGLPT38**
*************************SNGLPT38**
***********AUTO**5-DIGIT 95948T6**
***********AUTO**5-DIGIT 95948T6**
***********AUTO**5-DIGIT 95948T7**
***********AUTO**5-DIGIT 96122T28***
***********AUTO**5-DIGIT 96122T28***
***********AUTO**5-DIGIT 96122T28***
***********AUTO**5-DIGIT 96122T28***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
**********AUTO**MIXED AADC 926T1***
*************************SNGLPT38***
*************************SNGLPT38***
*************************SNGLPT38***
***********AUTO**5-DIGIT 95947T2***
***********AUTO**5-DIGIT 95948T6***
***********AUTO**5-DIGIT 95948T6***
***********AUTO**5-DIGIT 95947T2***

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]6788[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]735100[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]12[/TD]

[TD="bgcolor: #c0c0c0"]Unique List[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]6789[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]56[/TD]

[TD="align: right"]939069[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]

[TD="align: left"]*************************SNGLP[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]6790[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]163[/TD]

[TD="align: right"]111320[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]

[TD="align: left"]***********AUTO**5-DIGIT 95947[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]6791[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]86[/TD]

[TD="align: right"]104485[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]25[/TD]

[TD="align: left"]***********AUTO**5-DIGIT 95948[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]6792[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]103915[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]26[/TD]

[TD="align: left"]***********AUTO**5-DIGIT 96122[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]6793[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]45[/TD]

[TD="align: right"]938900[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]27[/TD]

[TD="align: left"]**********AUTO**MIXED AADC 926[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]7361[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]192[/TD]

[TD="align: right"]933626[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="align: right"]7362[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]193[/TD]

[TD="align: right"]933945[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="align: right"]7363[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]202[/TD]

[TD="align: right"]111434[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="align: right"]7381[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]249[/TD]

[TD="align: right"]938324[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

[TD="align: right"]7382[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]622170[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]99[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]

[TD="align: right"]7383[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]108113[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]100[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]

[TD="align: right"]7384[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]53[/TD]

[TD="align: right"]107942[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]101[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]

[TD="align: right"]7385[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]57[/TD]

[TD="align: right"]111240[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="align: right"]7386[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]67[/TD]

[TD="align: right"]934109[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]

[TD="align: right"]7387[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]68[/TD]

[TD="align: right"]110372[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]104[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]

[TD="align: right"]7388[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]103128[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]105[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]

[TD="align: right"]7389[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]111[/TD]

[TD="align: right"]104766[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]

[TD="align: right"]7390[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]112[/TD]

[TD="align: right"]385500[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]

[TD="align: right"]7391[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]118[/TD]

[TD="align: right"]108250[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]

[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]33[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]

[TD="align: right"]7441[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]91[/TD]

[TD="align: right"]103877[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]28[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]

[TD="align: right"]7442[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]92[/TD]

[TD="align: right"]937697[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]29[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]

[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]34[/TD]

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4



The desired result would be:
Sheet1

*CDEFGHIJ
*************************SNGLPT38
*************************SNGLPT38
*************************SNGLPT38
***********AUTO**5-DIGIT 95948T6
***********AUTO**5-DIGIT 95948T6
***********AUTO**5-DIGIT 95948T7
***********AUTO**5-DIGIT 96122T28
***********AUTO**5-DIGIT 96122T28
***********AUTO**5-DIGIT 96122T28
***********AUTO**5-DIGIT 96122T28
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
**********AUTO**MIXED AADC 926T1
*************************SNGLPT38
*************************SNGLPT38
*************************SNGLPT38
***********AUTO**5-DIGIT 95947T2
***********AUTO**5-DIGIT 95948T6
***********AUTO**5-DIGIT 95948T6
***********AUTO**5-DIGIT 95947T2

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:233px;"><col style="width:35px;"><col style="width:28px;"><col style="width:28px;"><col style="width:49px;"><col style="width:49px;"><col style="width:14px;"><col style="width:28px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]6788[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]735100[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]6789[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]56[/TD]

[TD="align: right"]939069[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]6790[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]163[/TD]

[TD="align: right"]111320[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]6791[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]86[/TD]

[TD="align: right"]104485[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]6792[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]103915[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]26[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]6793[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]45[/TD]

[TD="align: right"]938900[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]27[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]7361[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]192[/TD]

[TD="align: right"]933626[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="align: right"]7362[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]193[/TD]

[TD="align: right"]933945[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="align: right"]7363[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]202[/TD]

[TD="align: right"]111434[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="align: right"]7381[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]249[/TD]

[TD="align: right"]938324[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

[TD="align: right"]7382[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]622170[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]

[TD="align: right"]7383[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]108113[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]100[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]

[TD="align: right"]7384[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]53[/TD]

[TD="align: right"]107942[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]101[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]

[TD="align: right"]7385[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]57[/TD]

[TD="align: right"]111240[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="align: right"]7386[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]67[/TD]

[TD="align: right"]934109[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]

[TD="align: right"]7387[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]68[/TD]

[TD="align: right"]110372[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]104[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]

[TD="align: right"]7388[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]103128[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]105[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]

[TD="align: right"]7389[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]111[/TD]

[TD="align: right"]104766[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]

[TD="align: right"]7390[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]112[/TD]

[TD="align: right"]385500[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]

[TD="align: right"]7391[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]118[/TD]

[TD="align: right"]108250[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]

[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]

[TD="align: right"]7441[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]91[/TD]

[TD="align: right"]103877[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]28[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]

[TD="align: right"]7442[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]92[/TD]

[TD="align: right"]937697[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]29[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]

[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]34[/TD]

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4

Any leads would be appreciated. :eeek:
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Helper column approach - just put the formula in row 1 of the helper column and fill down, it will give you a new j column.

Code: 
=if(countif($c$1:c1,c1)=1,1,j1)
 
Last edited:
Upvote 0
Here's the same solution as Ragnar1211 he gets the credit he beat me to it. Mine just shows the results. I copied your original values from column H into the helper column L and the formula in the H column can be copied down.



Excel 2010
BCDEFGHIJKL
T38**
T38***************************SNGLP
T38*************AUTO**5-DIGIT 95947
T6*************AUTO**5-DIGIT 95948
T6*************AUTO**5-DIGIT 96122
T7************AUTO**MIXED AADC 926
T28***
T28***
T28***
T28***
T1***
T1***
T1***
T1***
T1***
T1***
T1***
T38***
T38***
T38***
T2***
T6***
T6***
T2***

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]6788[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]735100[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #C0C0C0"]Unique List[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]6789[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]56[/TD]

[TD="align: right"]939069[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]

[TD="align: right"]13[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6790[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]163[/TD]

[TD="align: right"]111320[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]

[TD="align: right"]14[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]6791[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]86[/TD]

[TD="align: right"]104485[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]25[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]6792[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]103915[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]26[/TD]

[TD="align: right"]26[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]6793[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]45[/TD]

[TD="align: right"]938900[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]27[/TD]

[TD="align: right"]27[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]7361[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]192[/TD]

[TD="align: right"]933626[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]7362[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]193[/TD]

[TD="align: right"]933945[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]7363[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]202[/TD]

[TD="align: right"]111434[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]7381[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]249[/TD]

[TD="align: right"]938324[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]7382[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]622170[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]99[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]7383[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]52[/TD]

[TD="align: right"]108113[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]100[/TD]

[TD="align: right"]100[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]7384[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]53[/TD]

[TD="align: right"]107942[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]101[/TD]

[TD="align: right"]101[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]7385[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]57[/TD]

[TD="align: right"]111240[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="align: right"]102[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]7386[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]67[/TD]

[TD="align: right"]934109[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]102[/TD]

[TD="align: right"]102[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]7387[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]68[/TD]

[TD="align: right"]110372[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]104[/TD]

[TD="align: right"]104[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]7388[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]103128[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]105[/TD]

[TD="align: right"]105[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]7389[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]111[/TD]

[TD="align: right"]104766[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]

[TD="align: right"]15[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]7390[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]112[/TD]

[TD="align: right"]385500[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]

[TD="align: right"]16[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]7391[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]118[/TD]

[TD="align: right"]108250[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]

[TD="align: right"]17[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]33[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]7441[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]91[/TD]

[TD="align: right"]103877[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]28[/TD]

[TD="align: right"]28[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]7442[/TD]
[TD="align: right"]249[/TD]
[TD="align: right"]92[/TD]

[TD="align: right"]937697[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]29[/TD]

[TD="align: right"]29[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]7392[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]74[/TD]

[TD="align: right"]935289[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]34[/TD]

[TD="align: right"]34[/TD]

</tbody>
Sheet21​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H1[/TH]
[TD="align: left"]=IF(COUNTIF($A$1:$A1,A1)=1,1,$L1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Formula to find Max number of items in orders
Replies
1
Views
660
fjns
F
Alphacsulb
  • Question Question
Count down numbering with Vlookup?
Replies
1
Views
329
skywriter
skywriter
K
  • Question Question
How to count occurrences of two or three numbers in different rows?
Replies
5
Views
509
Eric Golf
E
R
  • Question Question
Help!
Replies
3
Views
2K
63falcondude
63falcondude
V
  • Question Question
Sum function for different rows please
Replies
2
Views
564
Venkateshwara Iyer
V

Forum statistics

Threads
1,222,314
Messages
6,165,297
Members
451,950
Latest member
WH2000

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