I have an excel with more than 100 products. In Column A I have numbers that indicate if its a complete new product or if its a similar product.
When CurrentRow in Column A = 1, then we are talking of a new product. When The subsequent row is 2 or >1, then we are talking of similar prodcuts. When The subsequent row is 3 or >1, the we are still talking of a simiar product.
Finally when the Current Row meets a 1 again, we are takling of a new product.
With that info I intend to do the following:
If CurrentRow = 1 and CurrentRow + 1 = 1, then we are talking of a unique product, so then we will go to link in Column C, get link, use browser take screen shot and paste in Power Point with “Templeate 1”.
If CurrentRow = 1 and CurrentRow + 1 > 1, then we are talking of a product with similar products, so then we will get link in Column C, use browser, take screen shot and paste in Power Point using “Templeat 2”.
So my problem is more with the logics of how to express:
CurrentRow and a CurrentRow +1
I tried: IF Current Row = 1 and Current Row + 1 > 1
Just check for CurrentRow = 1 will do the work for your use case.