hi,
change serial number (Column T) and bill number (Column V) if the value of Column S value is greater then >0
hope some one will help
Capture.JPG
hi,
change serial number (Column T) and bill number (Column V) if the value of Column S value is greater then >0
hope some one will help
Capture.JPG
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Not tested:
Into Z5:
Into AA5:Please Login or Register to view this content.
drag both formulas down as needed.Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
I'd do it like below.
In some out of way cell, store seed value (or you can hard code it).
Then in AA5:
=IF(S5>0,$AD$2+COUNTIF($S$5:S5,">0"),"")
Copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Happy to help.
Thanks for rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks