Hello All,
I am in a finance job where I have a tracker to maintain the list of invoices, debit note and credit notes issued with the reference numbers, based on the region.
For example, ref# for Invoices, debit note and credit note for North region should start from 1000, for South 2000, etc.
Please refer the attached file for better understanding. This I need to do it in formula.
Any help appreciated.
Thanks,
aganesan99
In E2, I used
=VLOOKUP(C2,$I$2:$J$3,2,FALSE)+COUNTIFS($B$2:$B2,B2, $C$2:$C2,C2)-1
See attached.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks ChemistB
You saved my day.
Thanks a lot.
aganesan99
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks