QUESTION : I would like to have the data validation that is possible with having a dropdown but I would […]
Tag: google-spreadsheets
Get highest/lowest average in a table
QUESTION : I would like to know the highest and lowest average in a table based on a range of […]
How do I append a character to the end of every line in an Excel cell?
QUESTION : I have a column of Excel cells that’s similar to a grocery shopping list and looks as follows: […]
How to look a value and sum it into a certain cell
QUESTION : I have 2 columns, Space & Rows. I want to iterate over the Rows columns and sum only […]
Microsoft Word/Excel equivalent to the “Search the Menus” functionality of Google Docs/Sheets
QUESTION : In Google Docs/Sheets, I can hit Alt-/ (M-/ for Emacs users 🙂 ) to bring up a menu […]
Creating a table similar to pivot table
QUESTION : I’m not sure how to explain it, but I hope this example makes it clear. Data: Yes/No | […]
Find sum of totals made on a given day
QUESTION : I have this simple table of data in Excel and I need a formula to find the total […]
How to identify with a formula, multiple occurrences within a criteria for each row?
QUESTION : What is a good way to distinguish when there are duplicate entries given certain conditions. Here is an […]
How to tie cell choice from dropdown list to content of other cell
QUESTION : On a given range of cells, I have imposed the following data validation. The options come from a […]
Populate Spreadsheet with files within a folder
QUESTION : I need to manage a lot of files within folder related to a project, at the moment these […]