Hi,
I am trying to get this formula to extract the data from column H, but it is getting the data from column F instead... And I can't figure out why?
{IFERROR(INDEX(Orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, Orders!$C$3:$K$10000)*COUNTIF($C$3, Orders!$D$3:$D$10000), ROW(Orders!$C$3:$K$10000)-MIN(ROW(Orders!$C$3:$K$10000))+1), ROW($D1)), COLUMN($D1)),0)*1}
Please can someone help.... I know it will be easy for someone, sadly not me!
I am trying to get this formula to extract the data from column H, but it is getting the data from column F instead... And I can't figure out why?
{IFERROR(INDEX(Orders!$C$3:$K$10000, SMALL(IF(COUNTIF(A$32, Orders!$C$3:$K$10000)*COUNTIF($C$3, Orders!$D$3:$D$10000), ROW(Orders!$C$3:$K$10000)-MIN(ROW(Orders!$C$3:$K$10000))+1), ROW($D1)), COLUMN($D1)),0)*1}
Please can someone help.... I know it will be easy for someone, sadly not me!