Excel land today i had to create a uique column based on two columns that have non-continguous data (a blank space if the above row applies for the current row)
so i have a set like
List 1 List 2 Results
20W Fridge
Freezer
30W
30W Cxxxx
40W
40W xols
50W
where C8 and B8 are List 1 and List 2
=CONCATENATE((IF(C8="",(LEFT(G7,FIND("-",G7)-1)),C8)),"-",(IF(B8="",(RIGHT(G7,LEN(G7)-FIND("-",G7))),B8)))
results would be like 20W-Fridge, 20W-Freezer,30W-Freezer,30W-Cxxxx,40W-Cxxx,etc
No comments:
Post a Comment