Generate unique next number

[sradjend]

Hi Experts,

I need to generate the next alpha numeric number of a column which is not is sequence. Column A in the attachment represents the number which is formatted per country in Column B. when I select the country in Column E5, should check Column A and B and generate the next unique number for that country.

Thanks,
Senthil

[jindon]

UDF
Use in cell F5
=NextNumber([Country],Table2)

Please Login or Register  to view this content.

[sradjend]

Hi,

Thanks and appreciate your quick reply. I am not getting the result. Could you please attach the file where you achieved the result?

[sradjend]

I got it. thanks much

[jindon]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[sradjend]

Again. How to tackle these?

1. Insert one more conditional column. Ex: Type as Column C. next number should number return based on Type A + Country
2. If I have more columns in the sheet and these columns are available in random? how to refer these fields?

Thanks

[jindon]

Upload a workbook with the data and the result that you want.

[leelnich]

Hi all, here's another:

Please Login or Register  to view this content.

[leelnich]

1. Insert one more...column...next number should [be] based on Type A + Country...

This could lead to parallel numbers in different types. ie. Australia Type A ABN13999999511 and also Australia Type B ABN13999999511

[sradjend]

I want C5 in Sheet 3 to refer the table in sheet 2, Refer column I for Country selection + refer column M (contains string “Proxy”) and search for number in column J to generate the next number.

[jindon]

C5 in Sheet3
=GetNextNumber(Sheet2!$I$2:$M$29,2,1,[@Country],5,"*proxy*")

Where;
Sheet2!$I$2:$M$29 = Whole data range
2 = relative "Number" column index in whole data range from the left
After these, you can add as many conditions as you want.
Such like
1,[@Country] means 1st column of data should equal to [@Country] which is "AT" currently
5,"*proxy*" means 5th column of data should contains "proxy"

etc.

Please Login or Register  to view this content.