Tag Info

New answers tagged

0

Copy what you want from the Excel document to MS Word first, and then try to paste it into Gmail by coping it from MS Word.


2

Assuming you have a new line character in every cell and you want to extract everything before the new line, try: =ArrayFormula(iferror(regexextract(A2:A, "^(.+)\n"))) (where A is the column with the addresses and your data starts in row 2 --> change to suit). After that, you can copy the output and use 'paste special' (values only) to overwrite to ...


1

Another way of doing it, is by using the AVERAGEIF formula. Formula =AVERAGEIF(A1:B1, ">0") Screenshot


1

Here's a function to do thisif a1>0 and b1>0 then average a1 and b1 else add a1 and b1 =if(AND(A1>0,B1>0),AVERAGE(A1,B1),add(A1,B1)) Obviously you'll have to plug in your own cells for a1 and b1 You can find all the google functions documentation here


1

You could use the ImportRange function to sync cell data between two spreadsheets. You could then share the individual spreadsheets to your various students. ImportRange documentation: https://support.google.com/docs/answer/3093340?hl=en I've created an example for you, here is your master sheet: ...



Top 50 recent answers are included