Forum Discussion
Fn to find all cells in a column with exactly same text, then sum adjacent cells of matches
I have a "database" of parts. For instance, Part number 001, 002, 003, 004, etc. The Part name (ex: 001) is in column A. Each Part number has a location column (column B), and a quantity Column (col...
A PivotTable is probably most sensible but here's a formula solution:
=BYROW(Part,LAMBDA(row,IF(COUNTIF(TAKE(Part,ROW(row)-1),row)=1,SUMIF(Part,row,Qty),"")))