Forum Discussion
Solved
Automatic posting of numbers to correct column based on column heading and row titles
Can someone please tell me how the $ amounts in Spent Colum can automatically be posted in the column that matches payee name in the rows. I cannot get it to work. Thank you so much. PAYEE...
PamM2565 You didn't specify the Excel version you work with, so I've included two possible solutions in the attached file. One with a single dynamic array and one a regular formula copied down and across.
PamM2565 You didn't specify the Excel version you work with, so I've included two possible solutions in the attached file. One with a single dynamic array and one a regular formula copied down and across.
- Thank you so much for getting back to me. I a, using MS365, and thank you again. Pam
