Here is my dilemna:
I have 4 columns of data. Each column represents a segment of a general ledger account number.
The first column has about 54 rows, which represents the Fund. (5 characters)
The second column is the Account, and there are 71 of those. (6 characters)
The third column is the Program and there are 39. (3 characters)
Lastly there is the Project column and there are 9 of them. (2 characters)
So in essence I would like a formula that will generate all the accounts for me in this format:
XXXXX.XXXXXX.XXX.XX
54x71x39x9= 348,894 general ledger accounts
In addition, in the column following each of the columns is a short description. I would like to do the same thing above with the descriptions in the following format:
Fund descr-Account name-Program-Project
I have been trying to do this using the Concatenate function but to no avail. Can someone please help me?
Thanks
Gil
I have 4 columns of data. Each column represents a segment of a general ledger account number.
The first column has about 54 rows, which represents the Fund. (5 characters)
The second column is the Account, and there are 71 of those. (6 characters)
The third column is the Program and there are 39. (3 characters)
Lastly there is the Project column and there are 9 of them. (2 characters)
So in essence I would like a formula that will generate all the accounts for me in this format:
XXXXX.XXXXXX.XXX.XX
54x71x39x9= 348,894 general ledger accounts
In addition, in the column following each of the columns is a short description. I would like to do the same thing above with the descriptions in the following format:
Fund descr-Account name-Program-Project
I have been trying to do this using the Concatenate function but to no avail. Can someone please help me?
Thanks
Gil