Hi, I’m grateful if you could help me with some formulas on creating dashboard with what I’m looking for please. I’ve a data in worksheet1 as :
Stock. Gain or loss %. Col3. Col4.
ABC. 40%. 26d. 125
XYZ. 5%. 26d. 100
EFG. (11.4%). 26d. 90
And so on so forth.... Many rows.
How could I get data into second sheet from Sheet1 only when met the following conditions. I would like this data to be automatically populated in sheet2 every time when excel opens up or changes data in sheet1.
1. IF gain or loss >= 10%
2. IF gain or loss < 0%. (I.e. negative numbers)
3. IF again or loss > 0 and < 5%.
Thanks much for your help!
Stock. Gain or loss %. Col3. Col4.
ABC. 40%. 26d. 125
XYZ. 5%. 26d. 100
EFG. (11.4%). 26d. 90
And so on so forth.... Many rows.
How could I get data into second sheet from Sheet1 only when met the following conditions. I would like this data to be automatically populated in sheet2 every time when excel opens up or changes data in sheet1.
1. IF gain or loss >= 10%
2. IF gain or loss < 0%. (I.e. negative numbers)
3. IF again or loss > 0 and < 5%.
Thanks much for your help!