Can you separate a series of numbers by even and odd

[Eskonn]

I have a large series of numbers that I need separated by even and odd numbers.
Here is what the numbers look like. I have made the odd numbers red on the list below and the even numbers are black

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]19-11-1[/TD]
[/TR]
[TR]
[TD]19-11-2[/TD]
[/TR]
[TR]
[TD]19-11-3[/TD]
[/TR]
[TR]
[TD]19-11-4[/TD]
[/TR]
[TR]
[TD]19-12-1[/TD]
[/TR]
[TR]
[TD]19-12-2[/TD]
[/TR]
[TR]
[TD]19-12-3[/TD]
[/TR]
[TR]
[TD]19-12-4[/TD]
[/TR]
[TR]
[TD]19-13-1[/TD]
[/TR]
[TR]
[TD]19-13-2[/TD]
[/TR]
[TR]
[TD]19-13-3[/TD]
[/TR]
[TR]
[TD]19-13-4[/TD]
[/TR]
[TR]
[TD]19-14-1[/TD]
[/TR]
[TR]
[TD]19-14-2[/TD]
[/TR]
[TR]
[TD]19-14-3[/TD]
[/TR]
[TR]
[TD]19-14-4[/TD]
[/TR]
</tbody>[/TABLE]

The digit that determines if it is even or odd is the fourth number 19-14-1
When separating these I would like to separate the whole row.

Any suggestions would be great.
Thanks

 

[Eskonn]

Thank you helping with this problem.
I was able to get the A21 & J21 formulas to work.
The B21 & K21 are returning #N/A, I am trying to work through it to see what the error is.

Thanks for your time

Here is a formula way.
The formula for the Row # (cells A21 and J21) are array formula and must be entered with CTRL-SHIFT-ENTER then drag down as needed.
Formulas in B21 and J21 just copy down and across.Change ranges to match your data. They can be put on separate worksheets.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

<colgroup><col style="width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:27px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Material[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Size[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]VT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Stor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Qty[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]unit[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]7317515[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: center"]5986815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: center"]2836015[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: center"]6548715[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-4[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: center"]1589714[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: center"]1113410[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: center"]395915[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: center"]7117326[/TD]
[TD="align: center"]375[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: center"]5553015[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: center"]6250815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: center"]703510[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: center"]673815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: center"]262710[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="align: center"]2197115[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]
[TD="align: center"]10050648[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="align: center"]10001796[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-4[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Even #'s[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]ODD #'s[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Row #[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Material[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Size[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]VT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Stor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Qty[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]unit[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Row #[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Material[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Size[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]VT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Stor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Qty[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]unit[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]5[/TD]
[TD="align: center"]1589714[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]1[/TD]
[TD="align: center"]7317515[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]22[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]6[/TD]
[TD="align: center"]1113410[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]2[/TD]
[TD="align: center"]5986815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]23[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]7[/TD]
[TD="align: center"]395915[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]3[/TD]
[TD="align: center"]2836015[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]24[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]8[/TD]
[TD="align: center"]7117326[/TD]
[TD="align: center"]375[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-12-4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]4[/TD]
[TD="align: center"]6548715[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-11-4[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]13[/TD]
[TD="align: center"]262710[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]9[/TD]
[TD="align: center"]5553015[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]26[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]14[/TD]
[TD="align: center"]2197115[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]10[/TD]
[TD="align: center"]6250815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]27[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]15[/TD]
[TD="align: center"]10050648[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]11[/TD]
[TD="align: center"]703510[/TD]
[TD="align: center"]1.75[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]28[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]16[/TD]
[TD="align: center"]10001796[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]VT[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-14-4[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]12[/TD]
[TD="align: center"]673815[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]19-13-4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]CS[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]29[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "] [/TD]

</tbody>

Spreadsheet Formulas

Cell Formula A21 {=IFERROR(SMALL(IF(ISEVEN(MID($E$2:$E$17,5,1)),ROW($E$2:$E$17)-ROW($E$2)+1),ROWS($A$21:$A21)),"")} B21 =IF(A21="","",INDEX($A$2:$G$17,$A21,MATCH(B$20,$A$1:$G$1,0))) J21 {=IFERROR(SMALL(IF(ISODD(MID($E$2:$E$17,5,1)),ROW($E$2:$E$17)-ROW($E$2)+1),ROWS($J$3:J3)),"")} K21 =IF(J21="","",INDEX($A$2:$G$17,$J21,MATCH(A$1,$K$20:$Q$20,0))) <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[alansidman]

@Caleeco
Thanks much for the correction. That's what happens when you don't test your code. I was in a hurry to run some errands.

 

[AhoyNC]

OK, see if this helps.
Sheet1 has the data.
Sheet2 is even data.
Sheet3 is odd data.

Excel Workbook
	A	B	C	D	E	F	G
1	Material	Size	VT	Stor	Location	Qty	unit
2	7317515	750	VT	400	19-11-1	5	CS
3	5986815	750	VT	400	19-11-2	8	CS
4	2836015	750	VT	400	19-11-3	9	CS
5	6548715	750	12	400	19-11-4	8	CS
6	1589714	1	12	400	19-12-1	5	CS
7	1113410	1.75	6	400	19-12-2	3	CS
8	395915	750	12	400	19-12-3	9	CS
9	7117326	375	12	400	19-12-4	9	CS
10	5553015	750	VT	400	19-13-1	5	CS
11	6250815	750	VT	400	19-13-2	4	CS
12	703510	1.75	6	400	19-13-3	7	CS
13	673815	750	12	400	19-13-4	7	CS
14	262710	1.75	6	400	19-14-1	5	CS
15	2197115	750	12	400	19-14-2	4	CS
16	10050648	750	VT	400	19-14-3	7	CS
17	10001796	3	VT	400	19-14-4	4	CS
Sheet1 - This is the data

Excel Workbook
	A	B	C	D	E	F	G	H
1	Row #	Material	Size	VT	Stor	Location	Qty	unit
2	5	1589714	1	12	400	19-12-1	5	CS
3	6	1113410	1.75	6	400	19-12-2	3	CS
4	7	395915	750	12	400	19-12-3	9	CS
5	8	7117326	375	12	400	19-12-4	9	CS
6	13	262710	1.75	6	400	19-14-1	5	CS
7	14	2197115	750	12	400	19-14-2	4	CS
8	15	10050648	750	VT	400	19-14-3	7	CS
9	16	10001796	3	VT	400	19-14-4	4	CS
Sheet2 - Even data

Excel Workbook
	A	B	C	D	E	F	G	H
1	Row #	Material	Size	VT	Stor	Location	Qty	unit
2	1	7317515	750	VT	400	19-11-1	5	CS
3	2	5986815	750	VT	400	19-11-2	8	CS
4	3	2836015	750	VT	400	19-11-3	9	CS
5	4	6548715	750	12	400	19-11-4	8	CS
6	9	5553015	750	VT	400	19-13-1	5	CS
7	10	6250815	750	VT	400	19-13-2	4	CS
8	11	703510	1.75	6	400	19-13-3	7	CS
9	12	673815	750	12	400	19-13-4	7	CS
Sheet3 - Odd data