tbablue
Active Member
- Joined
- Apr 29, 2007
- Messages
- 488
- Office Version
- 365
- Platform
- Windows
I'm trying to mange and summarise a large data table.
This formula in F4 thru F1000
{=INDEX(WO_NUMS,MATCH(0,COUNTIF(WO_NUMS,"<"&WO_NUMS)-SUM(COUNTIF(WO_NUMS,F$4:$F4)),0))}
It returns unique values from the dynamic named range WO_NUMS.
How might I amend the formula so that values in a corresponding named range, PROJECT, must first be found in B4:B14?
Any assistance welcomed.
This formula in F4 thru F1000
{=INDEX(WO_NUMS,MATCH(0,COUNTIF(WO_NUMS,"<"&WO_NUMS)-SUM(COUNTIF(WO_NUMS,F$4:$F4)),0))}
It returns unique values from the dynamic named range WO_NUMS.
How might I amend the formula so that values in a corresponding named range, PROJECT, must first be found in B4:B14?
Any assistance welcomed.
