Thursday, February 21, 2013

My function of the day

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

Check Care Confirm Correct

 As I glance through the pages of a book I'm reading, I learn one crucial aspect of human interaction that is worth observing and modula...