Learning Curve
New Member
Creating scatter diagrams and Excel is looking in the A and B columns for duplicate combos of the (x,y) coordinates. Would someone please untangle this formula for me? =if(sumproduct((A:A=A2)*(B:B=B2))>1,B2,NA())
Thank you!
Thank you!