Forum Discussion
Multiple If formulas with conditions
I am in need a formula that will look at multiple conditions for the data I have. My sample data is below. If the value in A is the same, and the value in B is the same, then join the values ...
I've never used VBA or macro before. Once I copy this into the developer, what do I do?
No vba is used. The only thing you may need to account for in the formulas are the named items:
If your data has these defined names, you can plug the formula in and calculate.
PeterBartholomew1 - hats off to the Excel team for PIVOTBY/GROUPBY! I really like how these formulas read with the ETA. The only change I'd make is having the [filter array] argument appear after the 'function' argument.
Which formula didn't work? The second uses GROUBY which is only available on the insider's beta channel at the moment. Otherwise REDUCE 5.3 from above should work with non-insider channels.
