Forum Discussion
FInding a cell with a particular word in, then putting the next row's figure into a new cell
I receive bank statements which show amounts received from Paypal, Amazon and Another company in Column E over many pages, and the next column shows the amount received. I wish to not only calculat...
Peter thanks for the advice, I am unfamiliar with wildcards and will look into this as it is always good to increase knowledge with Excel. I will do my best to give this a go also.
Please find attached a copy of nabilmourad's workbook containing all the formula, including a copy of the original formula converted to employ defined names rather than direct references.
The final FILTER formula only works with Dynamic Array versions of Excel.