SI function incrementation

Hello everyone,


I have an excel table (see the attached file) and I would like to automate the incrementation of column C, I tried this function but there is still a malfunction:


= SI ($ B5 = "success", REPT ("0", 4-NBCAR (NB.SI.ENS ($ B $ 5: $ B5, $ B5, $ A $ 5: $ A5, $ A5) .SI.ENS ($ B $ 5: $ B5; $ B5; $ A $ 5: $ A5; $ A5); "")


In fact I tested a solution but it does not work yet and I would like you to do the same thing in the following way on the attached file:


- Starting from line 10, choosing the "fail" value generates in the column C and in the same row an empty cell


- Then line 12, the choice of the value "succes", gives as value "0001"
At this level everything is alright,


- Then for line 11, the choice of "success" gives "0001" and the previous value of line 12 changes from "0001" to "0002", this is where the problem arises, usually in line 12 the value should always remain "0001" and line 11 "0002" , and so on


Note that the test result entry is not done from top to bottom, but it can intervene at any level, for example it can start from line 10 and secondly line 11 etc. as the example described above


Thank you for repeating the test as described above, and thank you for proposing an adequate solution

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

I'm sorry, but I don't understand your question. However, I have had a guess...

in English, the formula in C5 is:

=IF(B5="","",IF($B5="succes",TEXT(COUNTIF($B$5:B5,"succes"),"0000"),IF($B5="echec",TEXT(COUNTIF($B$5:B5,"echec"),"0000"),"")))

See sheet for translation into French....

Try this:

=IF(B5="","",IF($B5="succes",TEXT(COUNTIFS($B$5:B5,"succes",$A$5:A5,A5),"0000"),""))

You will need VBA for this, I think. I'm hopeless with VBA, but can do a workaround, if needed. To be honest, you'd probably be better off closing this thread and re-posting a clear and complete description in the VBA sub-forum.