![]() ![]() ![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |