Forum Discussion

Copper Contributor

Jul 31, 2025

Solved

Auto-numbering for invoices

I used Xero for my invoicing and when i upload my spreadsheet to Xero i need to manually input the invoice numbers. Is there a way that i can use a formula to automat this process and save me tim...

excel

m_tarler
Jul 31, 2025
try
="INV-"&TEXT(XMATCH( [@Company], UNIQUE( [Company] ) ), "0000")
if it isn't formatted as a Table then replace [@Company] with A2 and [Company] with A2:.A9999

m_tarler

Bronze Contributor

Jul 31, 2025

try

="INV-"&TEXT(XMATCH( [@Company], UNIQUE( [Company] ) ), "0000")

if it isn't formatted as a Table then replace [@Company] with A2 and [Company] with A2:.A9999