Lookup multiple results that has gaps
Hi ,
My data is set-up in format. A B D E Hours DeptName Criteria Expected Results B 8.34 8.34 A 7.21 7.64 3.21 7.21 6.64 3.21 6.62 8.34 B 7.21 3.21 9.21 C 4.15 8.34 10.11 Column A has the hours. Column B has the Dept Names Cell D2 Has the criteria I would like a formula that returns multiple results for Dept B in cell E2 and filler down. I could use this formula: =INDEX(A$3:A$80,SMALL(IF(B$3:B$80=D$2,ROW(A$3:A$15 )-ROW(A$3)+1,""),ROWS(A$3¬:A3))) But if you notice that in column B has gaps between them anyway we could go around that? |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com