Give two rows based on one row

ANNI

New Member
Joined
Dec 21, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a table of data that contains purchases and sell values of currency. Both the sell and the purchased value is on one row in the table as it is one transaction. For accounting reasons i wish to take the data from one row and make it to two rows in an other table. I used the =IFERROR("SELLCOLUMN";"BOUGHTColumn"´) That way when i reach the end of the sell column it could go over to the bought column. The problem is that when i reach the end of sell column and move over to the bought column im still on the row thats just below were the data ends. I wish to restart from the top. I was thinking that i could use the total number of rows somehow but i cant figure out how.

Any ideas how i can solve this?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,561
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

It is difficult to tell exactly what you have, where it is and what results you want and where they should be.

MrExcel has a tool called “XL2BB” that lets you post samples of your data (and expected results) that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a “Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
 

Forum statistics

Threads
1,141,204
Messages
5,704,954
Members
421,372
Latest member
Jamie11

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
Top