Forum Discussion
Using IF command but referencing alternate rows - autofill
Hi, Please can some help me. How do I continue this sequence without having to manually adjust each equation? =IF($C6=$H$5,$D6," ") =IF($C8=$H$5,$D8," ") =IF($C10=$H$5,$D10," ") =IF($C12=...
Two options:
1. An array formula (enter using control+shift+enter!)
2. A pivot table.
See attached.
Thank you very much Jan :)