I have a table with position (junior, senior), salary, and an ID. I have done the following to find the highest salary for each position. SELECT position, MAX(salary) FROM candidates GROUP BY position; What I am getting: How I want…
In my example: https://docs.google.com/spreadsheets/d/1QQNTw_r9-q-FqVNwUoYklup73niZCFyO0VDUYImP5fo/edit?usp=sharing I'm using Google Forms as an eBay clone to sell rare items. Each bid is outputted from the form to the "Data" worksheet and then I have ArrayFormulas set up inside the "Processed" worksheet. The idea…
Sheet containing 1000+ product SKUs, and ~4000 images. Not every SKU will have the same number of images. Right now, it lists 1 image per line: SKU001 Image001_1.jpg SKU001 Image001_2.jpg SKU001 Image001_3.jpg SKU002 Image002_1.jpg SKU002 Image002_2.jpg SKU003 Image003_1.jpg ...and so…