Get instant live expert help on I need help with arrayformula google sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am trying to convert a Google Sheets document into an excel document and my formulas are not transferring over correctly. This is the formula from the Google Sheets document. ={"Positivity Number";ARRAYFORMULA(if(D3:D="Low", "0", (if(D3:D="Medium", "1", (if(D3:D="High", "2",))))))} I have this formula pasted in a title box that is labeled "Positivity Number". Can you please help me convert this formula into one that will work with Excel?
Solved by E. A. in 27 mins
Possible to pull in values from Google Adwords into Google sheets, using date range from Google sheets?
Solved by X. W. in 18 mins
I have a google sheets doc. on the sheet TEST in cell E28 I need it to search the sheet "DisplayShare/Zone Data" and bring up all the values from that sheet that show as #N/A. I have similiar formulas on the TEST sheet which use an ARRAYFORMULA
Solved by G. L. in 21 mins
Vlookup between google sheets?............
Solved by G. H. in 26 mins
Google sheets conditional formatting and
Solved by O. C. in 11 mins