hello
i have a "master' sheet that contains all the data from P1-P12 worksheets (it dumps the data into the master sheet).
from the master sheet, i then thru a formula figure out how many deals were "won" or are "pending" - see won or spending sheet
this is my formula in B10 on the won sheet - highlighted in yellow
{=IF(ISERROR(INDEX(Master!$B$10:$P$6009,SMALL(IF(Master!$P$10:$P$6009=Won!$P10,ROW(Master!$P$10:$P$6009)-ROW(Master!$P$10)+1),COUNTIF(Won!$P$10:$P10,$P10)),B$6)),"",INDEX(Master!$B$10:$P$6009,SMALL(IF(Master!$P$10:$P$6009=Won!$P10,ROW(Master!$P$10:$P$6009)-ROW(Master!$P$10)+1),COUNTIF(Won!$P$10:$P10,$P10)),B$6))}
basically from the list in the master sheet, im trying to show data all the corresponding metrics for deal taht was "won"
the issue is...for some reaosn and im not sure why....
B91, there is only one entry of P1W3 and nothing other data. can someone pls help me? the same thing occurs in the "pending worksheet"
id be very grateful. thx u
Bookmarks