=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..
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..