I have a slight problem
I know how to extract unique references from a list by using the advanced filter, but is there any way it can be done by a lookup or some other function?
I am using a SUMIF to add up all the entries to a specific account, but the list of account numbers changes month on month (some new one are added, and some are cleared so fall off the list).
So I have tables set up to extract the figures from a spreadsheet to sum up the figure, were i have an account number, then 8 spaces below (as the data i am extracting is to the right of these spaces), then the next account number, and so on until all of the accounts are listed.
Is there a way to pick out the unique accounts, and input them with the 8 spaces between, as doing it manually each month would take far too long as there are over 200 accounts
Thanks
I know how to extract unique references from a list by using the advanced filter, but is there any way it can be done by a lookup or some other function?
I am using a SUMIF to add up all the entries to a specific account, but the list of account numbers changes month on month (some new one are added, and some are cleared so fall off the list).
So I have tables set up to extract the figures from a spreadsheet to sum up the figure, were i have an account number, then 8 spaces below (as the data i am extracting is to the right of these spaces), then the next account number, and so on until all of the accounts are listed.
Is there a way to pick out the unique accounts, and input them with the 8 spaces between, as doing it manually each month would take far too long as there are over 200 accounts
Thanks