Forum Discussion
Solved
Auto populate a table using two filtered ranges from another table
Hi, sorry in advance if this has already been posted. I was wondering if there is a way to autopopulate a table using a separate table total with a custom filtered range on two columns. In th...
How about
=COUNTIFS('Table A'!D$12:D$22,"<>",'Table A'!$A$12:$A$22,OFFSET($A3,-MOD(ROW()+1,4),0),'Table A'!$C$12:$C$22,$B3)
See the attached version.
Crimzo Like so?
Hi Riny_van_Eekelen, this works really well thank you! Will definitely start using pivot tables!