Welcome to the AI Ready Blog, where we explore the evolving world of Artificial Intelligence and Generative AI in education, fostering dialogue, experimentation, and research to enhance teaching, learning, and collaboration across disciplines.
Note: Features may change with future updates.
In Excel and Google Sheets it sometimes feels like the formulas needed to make sense of your data require you to learn another language. If you’ve ever struggled with finding the right combination of VLOOKUP, SUMPRODUCT, TEXTJOIN, and IF combined with AND/OR to answer your questions, then AI is the helping hand that can help you convert a plain English request into spreadsheet-speak.
If you were looking at a large spreadsheet like this, you might wonder if you can focus in and only look at the data from 3 Bronx zip codes (10468, 10458, and 10469). I rephrased this question with the following prompt:
I have a spreadsheet where I’d like to only show the data from these three Zip Codes: 10458, 10468, and 10469, on a separate sheet. What formula would I need to use to accomplish this?
After I entered that prompt into one of the free AI tools available, Microsoft’s CoPilot, I received a response that not only provided the necessary formulas but also included a clear, step-by-step guide for accomplishing my request in Google Sheets.
I can help guide you through the steps.
To filter rows with specific Zip Codes (10458, 10468, and 10469) and display them on a separate sheet, you can use the FILTER function. Here’s how you can do it:
- Create a new sheet: In your Google Sheets document, add a new sheet by clicking on the “+” icon at the bottom.
- Use the FILTER function: In cell A1 of the new sheet, enter the following formula:
=FILTER(Sheet1!A:Z, (Sheet1!C:C = 10458) + (Sheet1!C:C = 10468) + (Sheet1!C:C = 10469))
Replace Sheet1 with the name of your original sheet, and adjust C:C to the column where your Zip Codes are located.
This formula will filter rows from the original sheet and show only those with the Zip Codes 10458, 10468, and 10469 in the specified column.
If you need any further assistance, feel free to ask!
So the next time you are unsure of how a complex spreadsheet formula should be constructed, try an AI helper to give you advice and an example that you can plug in and test drive.
Sponsored by the Fordham Faculty AI Interest Group | facultyai@fordham.edu | www.fordham.edu/AI
AI Events sponsored by the Fordham Faculty AI Interest Group