Excell mess

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I want a price from Column E if it has in Column F (next to it) the number 1 to go to Column Named GRoup 1 if it has number 2 tou go to Group 2 and if it has a number 3 next to it to be copied in Column NAmed group 3....what is the formula thaI need? pls tell me quickly!



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use if formula in your columns named GRoup 1 etc

=if(f1=1,e1,"")
0