I recently saw this post: Conditional Format Rows in List 1 that are Not in List 2
Last year I discovered David Hager’s Excel blog. As you have Excel 2013 this cool new function doesn’t yet exist and you see xlfn in front of the function.
He uses a cool new function and sends the file to you. You have Excel 2013 and your friend has a newer version of Excel (Office 365 or Excel 2016). Xlfn is a prefix added to functions that don’t exist in the version of Excel that you are using. Did you get too much sun? Did you eat some bad fish? Did you smoke one of Oz du Soleil’s cigars? You open your friend’s Excel file and discover that some of the formulas aren’t working and include the letters XLFN ! You call your friend but he says that everything looks perfectly fine on his laptop. Despite how amazing Excel is there are times when you’ll find yourself shaking with fear! For example, have you ever seen anything as scary as this =ISERROR(FIND(_xlfn.CONCAT($A2:$E2),_xlfn.CONCAT($I$2:$M$6))) What is xlfn ?
0 kommentar(er)
