Running Number Sequences 1-10 then change when value changes?

AndyGray

New Member
Joined
May 31, 2017
Messages
30
=IF(C6<>"",IF(C6=C5,D5+1,0),"")

What I'm looking to do with this (this works perfectly) is make it read 2 cells and check for a change in each one of them

If Cell C6 7 8 and 9 all read the same value. Then Row D will list 1 2 3 4 5 etc... until the value in C6 7 8 changes etc..

Now I want this same formula... But i want it to look for a change in cell B6 as well.



To summarize in my spreadsheet as is.. .Row B contains Item Numbers, Row C Contains Customer Numbers. Row C needs to run in sequence, unless the value in B or C changes..
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hi, it looks like your existing formula starts the sequence at zero - this option that you can try starts at one like your description.


Excel 2013/2016
CDE
5ItemCustSeq
6ACUST11
7ACUST12
8ACUST31
9ACUST32
10BCUST11
11BCUST12
12CCUST11
13DCUST11
14DCUST12
15DCUST13
16DCUST14
Report
Cell Formulas
RangeFormula
E6=IF(COUNTA(C6:D6)=2,IF(AND(C6=C5,D6=D5),E5+1,1),"")
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

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