Forum Discussion
How do I pull data from one sheet to another altering that data based on certain criteria?
Hey guys do you or anyone know if this is possible to do?
According to Column C “type of trade” related to Column E “Profits/Loss” of the same sheet, whether the dollar amount was positive or negative, can it be recorded in a different sheet as Win or loss? Win meaning it was a positive profit, Loss was negative.
*Not recording the dollar amount but recording if it was a Positive or negative “Win or Loss” In 2 separate columns of another sheet. Columns C and D.
For Ex: Sheet 1 Column C, the “type of trade” was “OTC MDBO.” Column E the “Profit/Loss” column is $400 so that would be recorded as 1 in Sheet 2 Column C the “win” column.
If column C of sheet 1 “type of trade” was “OTC MDBO” -$100 in Column E "Profit/Loss" that would be recorded as 1 in Column D Sheet 2 “loss column”
If there were multiple "type of trades" on 1 sheet, for ex: "OTC MDBO" 12 out of 2 were wins. I'm looking for a way to transform the profit or loss information to wins and losses. on a different sheet.
Basically, pulling the number of times that “Type of Trade” was logged from Sheet 1 Column C, Differentiating the positive or negative dollar amount in the same sheet column E, recording them as a win or a loss in 2 separate columns of another sheet. Column C for wins, Column D for losses.
Sheet 1 is called- Trade LOGS
Sheet 2 is called- Trade Tracking
- Please attach/share the sample file.
