Excel formula for copy data from cells to antother cells

shayan kamalzadeh 0
Viewed 27

I need a excel formula for copy data from a column to another column with a conditional situation.
please see below picture:

enter image description here

I have two columns with eu and ru name. I want to copy "eu" data rows if the header of the first column is "eu" and if I change "eu" to "ru" all data in "ru" copy to the blue part.

excel-formula excel
2 Answers

If you are on Microsoft-365 then could try-

=FILTER(E2:F7,E2:F2=B1)
Harun24hr0

This can be done by a simple =IF(), is it not? Like in the example =IF(D1="eu",A2,B2), as in the following screenshot:

enter image description here

Dominique0
Related