Test multiple variables in different columns

**I.am.Rustam** · 10-10-2016, 07:13 PM

Hi Guys,

I need help figuring out formula or perhaps macro?

I have a table: (a,b,c)

3 2020 4.2
4 2017 5.0
2 2019 5.2
1 2025 2.7
3 2022 5.6
1 2026 2.9

I need to construct a table that would get a value from a column C, test it and if true, paste the corresponding value from column B. I also need to test the column A. So my table should look like this:

Each column gets a weight/value of 1.

Row 1:

A1 B1 C1 D1 E1 F1 G1 H1 I1 etc...
2025 2025 2025 2026 2026 2026

Row 2:
A1 B1 C1 D1 E1 F1 G1 H1 I1 etc...
2019 2019 2019 2019 2019 2019

Row 3:
A1 B1 C1 D1 E1 F1 G1 H1 I1 etc...
2020 2020 2020 2020 2020 2022 2022 etc..

The first value for "1" in column C is 2.7. So I need to paste 2025 for Row 1 until the condition is true (until 2.7 is greater than A1 (which has a value of 1) and B1, (A1+B1=2). Ideally, if it is greater than the whole number I would need to paste it. So even though 2.7 is less than 3 (A1+B1+C1), I would still need to have 2025 in column C.

Then the next value in the table for 1 is 2.9. So I need to add 2.7+2.9 and do the same thing going forward...

Some idea for rows 2,3,4 etc..

Any ideas? Please help!

Thanks a lot!

**bebo021999** · 10-10-2016, 08:26 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**TheN** · 10-10-2016, 08:36 PM

If I understand correctly,

Your A column is the Row number.
Your B column is the desired output (if it's column() value is less than the corresponding C value)
Your C column determines when to change the B value.

You'd probably be better off with a macro for this particular problem, since the only solutions I can think of involve array formulas, and given how exponentially large this table will get, that's probably a bad idea...

Unfortunately, I am not well versed in macros, so hopefully someone else can be of assistance.