hello,
I have data on the left column and would like to move them to the correct column.
For instance the value for b2=red and a2= the data for red and i want it to move it to column d2.
Is there a formula for this?
Also, is there a formula for a range so that cell d2 will contain all data based on a value within a range of cells?
Thanks
I have data on the left column and would like to move them to the correct column.
For instance the value for b2=red and a2= the data for red and i want it to move it to column d2.
Is there a formula for this?
Also, is there a formula for a range so that cell d2 will contain all data based on a value within a range of cells?
Thanks