Forum Discussion
Solved
Extracting relationships from a heat map
Hi there, I have been trying to figure out a way on how to use multiple formulas to extract information from a heat map. I am trying to identify all the departments that interact with eachother by se...
=IFERROR(INDEX(Tabelle1!$C$2:$AF$2,,SMALL(IF(OFFSET(Tabelle1!$C$3:$AF$3,MATCH(Tabelle2!$B$4,Tabelle1!$B$4:$B$33,0),0)=$B$2,COLUMN(Tabelle1!$A:$AD)),ROW(1:1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
See the attached version. Should work in Excel in Office 2021, Microsoft 365 and in Excel Online.