Using function to format data based on Index-match function

[windiestboat]

Hello,

I am trying to understand if I can use a series of functions to format an invoice and isolate data that lacks a unique indicator. As opposed to a macro

Imagine I have the following data:

i want to produce the following two invoices:

i can use index-match to fill in the data for each individual account but is there someway I can automatically have excel separate the individual accounts for each group using "a" or "b" or "c" etc.. as the only hard coded input? and then can i have excel index match for each account and subsequently the amount due?

Ideally i want to say produce an invoice for "a", "b", or "d" and have all the corresponding data formatted automatically. Perhaps i can use an if(counta function? if a>1 do x,y,z etc...

thanks for the help!

 

[Larry Haydn]

Maybe another method is to use a pivot table, filter them by account, like this:

 

[windiestboat]

Hi Larry, Thank you for your reply. That may work in a number of instances.