Combine all accounts that end in D

[Ali]

I have many accounts that end in the letter D such as
L4030D and 002D and other that do not. I want to combine
all the accounts that end in D. How do I do this?

Thanks,
Ali

 

[otium]

not sure what you mean by combine but....

assume the account cell is A1, the command =IF(RIGHT(A1,1)="D"......
should help you

Ala

 

[Bernie Deitrick]

Ali,

Use a helper column with a formula like

=Right(A1,1)

and use that as the filter (use D) or field source of your pivot table.

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
what do you mean with 'combine'?

 

[kkknie]

If you are adding up one column based on accounts that end in "D" you
can use:

=SUMPRODUCT(--(RIGHT(A1:A5,1)="D"),B1:B5)

Where column A has the account and column B is what you are adding.

K

 

[David McRitchie]

Or use the helper column for a Filtered list (instead of Pivot Table)
Select the helper column then Data, Filter, Auto Filter

Or And if you wanted to sort so that D accounts were separate
=IF(right(a1,1)="D","D,'')

 

[Ali]

Thanks! It worked.

 

[Dave Peterson]

Or even use the builtin "Ends with" option (under Custom) if staying with the
data|filter|autofilter.