Hi guys,
I'm new to VBA programming and I need to write a loop for the following issue:
- Companies identified as R&D intense (1 = intense, 0=else)
- If a company displays R&D intensity twice during the sample period, starting from the second observation, the company is classified as high intensity R&D (1=high, 0=else)
- See the picture below, the "intensity" column shows what I would like to achieve using the loop.

tnx for your help!

excel vba1.jpg