Excell mess

Closed
Ditti - 28 Sep 2011 à 05:32
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Sep 2011 à 16:53
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!



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Sep 2011 à 16:53
you can use if formula in your columns named GRoup 1 etc

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