HELP Needed - Need direction.

jamesmev

Board Regular
Joined
Apr 9, 2015
Messages
233
Office Version
  1. 365
Platform
  1. Windows
If you're like me you get excited when there is a challenge with a formula or process. Well. I am stumped. And I could use the collective knowledge of people here.
I have a spreadsheet where there are two rows which provide details to everything beneath it (Example: I2 is "cost") and the "details" from E6 until xldown is aligned to the "cost" e2. That is "easy" enough. However, "cost" can repeat an "x" number of times with the "details" below x number of times. I am at a loss on how to make this work.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
What do you have for a formula right now. What exactly are trying to resolve? Can you post an example of the data with expected results?
 
Upvote 0
What do you have for a formula right now. What exactly are trying to resolve? Can you post an example of the data with expected results?
I have nothing as I am lost on this one. (again where the starts are are variable).

Cost on E2 = 15.00
Details starting on E6 - Item 1
Item 2
Item 3
Item 4
Item 5

Cost on E 15 = $25
Details starting on E19 - Item 6
Item 7
Item 8

What i Need
Item 1 $15
Item 2 $15
Item 3 $15
Item 4 $15
Item 5 $15
Item 6 $20
Item 7 $20
etc.
 
Upvote 0

Forum statistics

Threads
1,215,073
Messages
6,122,975
Members
449,095
Latest member
Mr Hughes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top