ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 416 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Arrange multiple columns into one |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
2 basic options to choose from
Assuming List A is in Column A data starting from row 2 & you only have numerical values & also only 1 entry per row you could easily use the sum formula:
=sum(A2:D2)
if you have multiple entries per row it will total these, and if you have non numerical data it will not work.
More complex you could use the following for all scenario's:
=if(A2<>"",A2,if(B2<>"",B2,if(C2<>"",C2,D2)))
Regards
Mark