I have a small formula request. I have downloaded my credit card statements from AmEx and I am trying to organize it in a way that I can have all my purchases added based on my text criteria of certain purchase... Ill try to be as clear as possible. I have already organized it in a way that when I paste new months statement in my Excel file it sorts it by date, newest on the top, and I made Conditional Formatting by color on column D which states the Description of purchase. Starbucks appears in description cell but it is followed by number and location making each Starbucks cell in column D different in name. So its hard to use Exact phrase formula to combine the amount for that purchase. My question is: Is there a formula that find a PORTION of text in a D column and automatically adds the price to the right of it together in one cell. There is a formula that looks for the whole text in the cell but that doesn't work when my name has always some extra numbers at the end of the word Starbucks
I have 5 columns (A,B,C,D,E) A=Date, B=Reference, C=Price, D=Description, E=Contact. I would like Excel to look in column D for portion of the work in each cell (EXAMPLE: D4=STARBUCKS USA 834NEWYORK, D30=STARBUCKS USA 387DENVER EXT...) so I would use word STARBUCKS since it is the only word that repeats and used it in a formula to SUM C column corresponding to each Starbucks cell in D column. Also note that I would like to set it to infinity since ill be pasting more statements as time goes by. With each one of these purchases filtered I would then be able to create graphs of spending by each criteria. My idea is to find out what my spending are for certain everyday product so I can see where I can cut down on expenses. Since we are in economy shift these days this would be great project for everyone. I hate looking through my statements in their very unclear way. Thank You for anyone who helps this means a big deal to me and I have been trying to look for it online for quite a while.....
Bookmarks