I have a template where there’s a guestlist on one tab.

I have a template where there’s a guestlist on one tab.

This question already has answers here: Better way to calculate time between two datetimes in Google Sheets? (2 answers) Closed 2 hours ago. A sheet that receives imported data has 4 cols. Col A has Datetimes, and in Col D I’d like to use an arrayformula to calc the minutes elapsed from the previous to […]

I made an example – https://docs.google.com/spreadsheets/d/1xRl1vBttWToJeDjJB4Okd6FKidLyvoPF2uXJmLCOzPI/edit?usp=sharing

I made an example – https://docs.google.com/spreadsheets/d/1xRl1vBttWToJeDjJB4Okd6FKidLyvoPF2uXJmLCOzPI/edit?usp=sharing

I got a Sales Promotions spreadsheet where I must have a Column which shows the Rows of conflicts of same product being promoted in same dates and different sales representatives.

I got a Sales Promotions spreadsheet where I must have a Column which shows the Rows of conflicts of same product being promoted in same dates and different sales representatives.

I need a specific formula that would give me the position of a cell in a column (Data!A:A) based on values form another range (A:A). Those values are strings of numbers that can be found as sub-strings of the values in Data!A:A.

In Google Sheets, I’d like to use something like arrayformula() to apply a formula to an entire 2-dimensional array, where the arguments of the formula are taken from the row/column headers.

I have a sheet with a pivot table. I want to return it by line to import it elsewhere. I created an array formula for this.