Non Blank Matches

[Legacy 436357]

Hello,

Is there a formula to retrieve non blank matches in column D?

Thank you

Excel Workbook
	A	B	C	D
1	ID	Sales Order	Unique IDs	Sales Order
2	10		10	matching Sales Order Numbers
3	10	50	20	matching Sales Order Numbers
4	10			matching Sales Order Numbers
5	20			matching Sales Order Numbers
6	20			matching Sales Order Numbers
7	20	100		matching Sales Order Numbers
8	20			matching Sales Order Numbers
9	20			matching Sales Order Numbers
10	20			matching Sales Order Numbers
Sheet3

 

[Legacy 436357]

What if it's like this?

Excel Workbook
	A	B	C	D
1	ID	Sales Order	Unique IDs	Sales Order
2	10		10	50
3	10	50	15	0
4	10		20	100
5	15
6	20
7	20
8	20	100
9	20
10	20
11	20
Sheet3

 

[Marcelo Branco]

What are the desired result in this situation?
50 in D2 (ok)
100 in D3 beside 15 (???)
Empty beside 20 (???)

M.

 

[Legacy 436357]

Desired results:

50 in D2
100 in D3
rest of column D blank

Column C will be hidden

 

[Marcelo Branco]

I would change the array formula in C2 to
=IFERROR(INDEX($A$2:$A$11,MATCH(0,--(SUMIF($A$2:$A$11,$A$2:$A$11,$B$2:$B$11)=0)+COUNTIF($C$1:C1,$A$2:$A$11),0)),"")
Ctrl+Shift+Enter
copy down

D2 copied down (post 2)
=IF(C2="","",SUMIF($A$2:$A$11,C2,$B$2:$B$11))

M.

 

[Legacy 436357]

Thank you so very much that is perfect!

 

[Marcelo Branco]

You're welcome. Glad to help

M.