Need a formula

[Richud90]

Hi, very stuck but determined to find a solution.

I have on Sheet 1 on Column A a range of data relating to electrical cables. In column E each cable has No of cores. example below

Cable No	Type	Size (mm2)	No of Cores	Counter
P-MCC-001			4	4
E-MCC-LET1			2	5
C-BEA001	1		1	6
C-SOU001			1	7

Cable No Type Size (mm2) No of Cores Counter
P-MCC-001 4 4
E-MCC-LET1 2 5
C-BEA001 1 6
C-SOU001 1 7


I've used =IFERROR(INDEX(Sheet3!A:A, MATCH(ROWS($A$2:A2) + 3, Sheet3!E:E, 1)),"Error")

But that is given the wrong amount of rows.

I'm trying to automatically pick up the data from A2 and transfer it onto Sheet 2 but by the number of cores for example:

P-MCC-001
P-MCC-001
P-MCC-001
P-MCC-001
E-MCC-001
E-MCC-001
C-BEA001
C-SOU001

I've used a cumilative counter and IFERROR formula however it doesn't seem to work as the cumulative counter will start at 4 so i think its causing issues.

[Pete_UK]

If you think your problem is urgent, then you should do all you can to help the people who might help you. It would certainly help if you attached a sample workbook - you can do this by following the guidelines given in the yellow banner heading at the top of the screen.

Hope this helps.

Pete

[zbor]

Try this in your sheet2:

=TEXTSPLIT(TEXTJOIN("||",TRUE,REPT(Sheet1!A2:A10&"||",Sheet1!D2:D10)),,"|",TRUE)

Also, it would be nice to have thread title into something more descriptive

[Richud90]

My apologies, spreadsheet uploaded.

Really appreciate the help

[Fluff13]

How about

=TOCOL(IF(SEQUENCE(,MAX(Sheet1!D2:D100))<=Sheet1!D2:D100,Sheet1!A2:A100,1/0),2)

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.