Formula with ranges
 

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

Formula with ranges
 

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

Formula with ranges
 

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

Formula with ranges
 

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