Previous Topic Next Topic

Excell mess

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

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

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

Similar discussions

Messenger missing emojis
poldoms -
ellielo -

2 responses
If Statement Excel
KoTTen -
vcoolio -

1 response
Spilled water on my keyboard keyboard mess up
ephemeral3 -
xpcman -

1 response