New answers tagged

0

You can first FILTER your range so that you're just left with the rows that you want. This would look like this =FILTER(C2:D6, C2:C6 = 1). Then you'd need to somehow join the values in cells you've filtered. You could use TEXTJOIN for this =TEXTJOIN(",", TRUE, TO_TEXT(F6), TO_TEXT(F7)). I have cells from column F in my TEXTJOIN because that is ...


0

One easy way to manage recurring images such as logos is to create a column, say column I, that holds them all. You can fetch the images into column I with image() formulas like this: =image("http://loodibee.com/wp-content/uploads/nfl-arizona-cardinals-team-logo-2-300x300.png", 1) Then refer to the image column whenever you want to display an image,...


0

Your data table looks nice and pretty — i.e., it is like a report. The best practice is to keep your data row-oriented and simple, and create reports separately — do not try to make your data look like a report. You may want to use a row-oriented data layout, like this: Name             Subject     Quarter   Score Marie Curie       Chemistry   Q1       100 ...


0

FILE > DOWNLOAD > MICROSOFT EXCEL


Top 50 recent answers are included