I have a list of reference numbers in a column with coordinating costs. Here is a similar example (full excel file attached):
I need an equation that can recognize matching text in a column, then add the corresponding numbers in the next column over. There is no pattern to tell when only two need to be added, or three, or more.
Another solution would be to filter out all the text that have 3 or more matches, leaving only the ones with two matches (like A1 and A2 in the above example) and from there adding them.
Thanks in advance!excel help adding columns.xlsx
Last edited by John Davis; 2011-10-18 at 04:02 PM.
Never mind, found another way