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 As a variant, a Pivot Table might do what you ask for, though in a slightly different format.
- Hi Riny_van_Eekelen, thank you for your reply and suggestion, I haven't used Pivot Tables but will give it a look. I poorly worded by above question and meant to ask if the grey highlighted totals can be put into the information rather than the raw data per depth and unit. i.e. Unit 1 at 1 m has a total data 1 value of 3. Will see if I can do this with the pivot plot!
Crimzo Like so?
- Hi Riny_van_Eekelen, this works really well thank you! Will definitely start using pivot tables!
