complex split formula needs amendment for breakdown per column

[JEAN1972]

I have column C with description , column D represents a serial no, COLUMN G represent the quantity.

Column R to T represents breakdown from column G and C .

For breakdown, Column C represents serial no for 39232120 which is the criteria for breakdown but due to some new description at row 32 getting invalid value

column R

Can anyone assist for formula or a vba solution as formula is very complex

Please Login or Register  to view this content.

column S

Please Login or Register  to view this content.

column T

Please Login or Register  to view this content.

column U

Please Login or Register  to view this content.

[maras_mak]

Hi, I suggest a VBA solution. The results are in columns from T32 and U32. Copy the code to the VBA module and run.

Please Login or Register  to view this content.

Regards.

[Bo_Ry]

Please try below and copy both down.

T2

=IFERROR(-LOOKUP(1,-MID(SUBSTITUTE(RIGHT(C2,20),U2,""),MIN(FIND({0,1,2,3,4}+{0;5},SUBSTITUTE(RIGHT(C2,20),U2,"")&1/17)),{1,2,3})),"")

U2

Please Login or Register  to view this content.