Aug 24 2022 05:57 AM
SC-01760 to be indicated in subsequent rows in a progressive manner. I had used the following formula such that it checks the next column if “SPARE” then it should put “-01761” otherwise it should put “SC-01761”. When I used the formula it is ignoring the zero. How can this be achieved.
Aug 24 2022 06:03 AM
Aug 24 2022 10:02 PM
@mtarler Thanks for your reply. I couldn't get the result as I wanted.
I have attached the sample file and the requirement is that the starting zero is missing . Hope I could convey properly what I am looking for and where I am wrong.
Aug 24 2022 10:34 PM
Your description does not match the content.
And the cell references in the formulas look weird.
Please revise your file and description.
Aug 25 2022 03:54 AM