Flora Edwards
New Member
this is my first question on Chandoo Excel forum.
i have heard a lot from a colleague about this forum and hopefully, i will get help here, while the question can be very challenging for Excel Gurus here.
I have been using Google Spreadsheet for quite sometimes and now our company have moved to Office 365 and now most of my formula used in Google sheet is not compatible with Excel. the most common formulas i used are in my work files are the following google spreadsheet functions.
before posting this question, i have googled alot, just to make sure not to reinvent the wheel if there is already something available. but i failed to find any UDF that i can use in my excel file to work like the google spreadsheet functions.
i would greatly appreciate if someone could help me with UDFs to work in Excel as a replica of google spreadsheet functions.
thank you for your help in advance.
UNIQUE
SORT
IMPORTDATA
IMPORTRANGE
IMPORTXML
JOIN
ARRAYFORMULA
FILTER
i have heard a lot from a colleague about this forum and hopefully, i will get help here, while the question can be very challenging for Excel Gurus here.
I have been using Google Spreadsheet for quite sometimes and now our company have moved to Office 365 and now most of my formula used in Google sheet is not compatible with Excel. the most common formulas i used are in my work files are the following google spreadsheet functions.
before posting this question, i have googled alot, just to make sure not to reinvent the wheel if there is already something available. but i failed to find any UDF that i can use in my excel file to work like the google spreadsheet functions.
i would greatly appreciate if someone could help me with UDFs to work in Excel as a replica of google spreadsheet functions.
thank you for your help in advance.
UNIQUE
SORT
IMPORTDATA
IMPORTRANGE
IMPORTXML
JOIN
ARRAYFORMULA
FILTER