Sublist on Excel

0 votes

I need a list in Sheet1 of the Op# of just the individuals in Sheet2 who are under the age of two. The example is below. If you can, briefly explain what the formula does.

enter image description here

I tried copying an array formula using index, tiny, if, and row, but I am unable to modify it in my worksheet since I don't understand what the formula is doing.

Feb 21, 2023 in Others by Kithuzzz
• 38,000 points
391 views

1 answer to this question.

0 votes

Try using this formula in sheet 1 

=FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2)

The first argument establishes the range to return a value from, while the second argument establishes the requirements.

When the number of rows from sheet 2 is returned, the formula should immediately expand vertically to that number.

answered Feb 21, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
7,946 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
4,264 views
0 votes
0 answers

Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

from instabot import Bot import openpyxl import smtplib bot = ...READ MORE

Sep 26, 2022 in Others by Kithuzzz
• 38,000 points
834 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,276 views
0 votes
1 answer

Sort list by frequency in python

You can try the following for a ...READ MORE

answered May 13, 2019 in Python by SDeb
• 13,300 points
6,303 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
954 views
0 votes
1 answer
0 votes
1 answer

Excel VBA to change background image of shape by clicking on shape

You need to keep track of what ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
2,966 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
644 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP