I need a formula that will allow me to reference a list of store names ONCE in another column but not paste duplicates. So for example, I have a list of invoices from stores
on one sheet. I need to reference these same stores and reflect store totals on another sheet based on the information from the first sheet but I only need to list each store once. See example below
SHEET 1
<tbody>
</tbody>
SHEET 2
<tbody>
</tbody>
Thanks for any help.
Rachel V in Florida
on one sheet. I need to reference these same stores and reflect store totals on another sheet based on the information from the first sheet but I only need to list each store once. See example below
SHEET 1
COLUMN A (STORE) | COLUMN B (INVOICE AMOUNT) |
STORE A | 150.00 |
STORE A | -2.65 |
STORE A | 50.00 |
STORE A | -8.35 |
STORE B | 24.65 |
STORE B | -9.45 |
STORE C | 87.00 |
STORE C | -4.50 |
<tbody>
</tbody>
SHEET 2
COLUMN A (STORE) | COLUMN B (TOTALS) |
STORE A | $189.00 |
STORE B | $15.20 |
STORE C | $82.50 |
<tbody>
</tbody>
Thanks for any help.
Rachel V in Florida