Dear all

I need help in order to produce a formula
as you can see in the attached file i have in column C some codes from a
system

The formula should be in column A
and it must bring the code from column C per category in front of each
product.
For example in C4 there is a code.
I wan to bring this code in Column A for lines A7 - A22

Then in the following to bring the code from C25 in front of A28 -A44
The problem is that there is not a specific range for the paragraphs. Some
of them are 10 lines, other 2 or 3 lines and there are some of 200 lines.
Imagine that all file should include more thatn 10.000 lines.

Thank in advace
Manos

Copy following formula inti A1;A337:
=IF(ISNUMBER(B1),INDEX(C:C,LARGE((B$1:B1="Manufact ured
Ite")*ROW(B$1:B1),1)),"")

HTH
--
AP

"Manos" a écrit dans le message de news:
...
Dear all

I need help in order to produce a formula
as you can see in the attached file i have in column C some codes from a
system

The formula should be in column A
and it must bring the code from column C per category in front of each
product.
For example in C4 there is a code.
I wan to bring this code in Column A for lines A7 - A22

Then in the following to bring the code from C25 in front of A28 -A44
The problem is that there is not a specific range for the paragraphs. Some
of them are 10 lines, other 2 or 3 lines and there are some of 200 lines.
Imagine that all file should include more thatn 10.000 lines.

Thank in advace
Manos

I forgot to mention:
This is an array formula, to validate by Ctrl+Shift+Enter, not just Enter.

--
AP

"Ardus Petus" a écrit dans le message de news:
...
Copy following formula inti A1;A337:
=IF(ISNUMBER(B1),INDEX(C:C,LARGE((B$1:B1="Manufact ured
Ite")*ROW(B$1:B1),1)),"")

HTH
--
AP

"Manos" a écrit dans le message de news:
...
Dear all

I need help in order to produce a formula
as you can see in the attached file i have in column C some codes from a
system

The formula should be in column A
and it must bring the code from column C per category in front of each
product.
For example in C4 there is a code.
I wan to bring this code in Column A for lines A7 - A22

Then in the following to bring the code from C25 in front of A28 -A44
The problem is that there is not a specific range for the paragraphs.
Some
of them are 10 lines, other 2 or 3 lines and there are some of 200 lines.
Imagine that all file should include more thatn 10.000 lines.

Thank in advace
Manos

Thank you Ardus
it works perfect

Ο χÏ�ήστης "Ardus Petus" Î*γγÏ�αψε:

I forgot to mention:
This is an array formula, to validate by Ctrl+Shift+Enter, not just Enter.

--
AP

"Ardus Petus" a écrit dans le message de news:
...
Copy following formula inti A1;A337:
=IF(ISNUMBER(B1),INDEX(C:C,LARGE((B$1:B1="Manufact ured
Ite")*ROW(B$1:B1),1)),"")

HTH
--
AP

"Manos" a écrit dans le message de news:
...
Dear all

I need help in order to produce a formula
as you can see in the attached file i have in column C some codes from a
system

The formula should be in column A
and it must bring the code from column C per category in front of each
product.
For example in C4 there is a code.
I wan to bring this code in Column A for lines A7 - A22

Then in the following to bring the code from C25 in front of A28 -A44
The problem is that there is not a specific range for the paragraphs.
Some
of them are 10 lines, other 2 or 3 lines and there are some of 200 lines.
Imagine that all file should include more thatn 10.000 lines.

Thank in advace
Manos