I have a series of invoices in column B and an SL no. in column A. I have kept the sl no. same for a few invoices to make sumif for other purposes. Now, what my query is, I am trying to get all the invoice nos. separated with a comma in a single cell in the D column. As I type the SL no. in the cell D2, the invoices nos should come in a series of correspondent SL no separated with a comma.
The example is as below,
A B C D
SL INV NO. SL
1 MOH001 INV NO. IN A SERIES SEPARATED BY COMMA-
1 MOH002
1 MOH003
2 REF009
2 REF010
2 REF011
2 REF012
Bookmarks