Required the total of odd number of each doc.no and mention count no.from excel working

[PRADEEPB270]

I have a file with so many datas.But here for requirement is total of all odd number of each document and mention the count no.against each doc.no.Is it possible through Excel working?

For more clarification,please refer the attach file.

[dilipandey]

Hi Pradeep,

Try using below array formula:-

{=INDEX($B$4:$D$13,SMALL(IF(MOD($D$4:$D$13,2)=1,ROW($D$4:$D$13)-3,""),ROW($A1)),COLUMN(A$1))}

see attached:-
Book1(33).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[PRADEEPB270]

Thank you very much sir.It has saved a lot of time of mine.

Regards

[dilipandey]

You are welcome Pradeep..

Regards,
DILIPandey

<click on below 'star' if this helps>