In a excel formula I need to create a list of names on one sheet based upon criteria data of another sheet

0 votes
I have two sheets: the first is a running operation report that updates people and workflow performance throughout the day, and the second is just data on the staff and the expected workload for the day. I require an excel formula that will search the list of employees in "column B" of the data sheet and extract a list of names according to their availability status in "column A" of the data sheet. There are other statuses, but I simply need "Aval" at this time. The names must then be entered into "column I" of the operations sheet in a columnar style, with no blank spaces or double entries.

Any help would be appreciated.
Nov 25, 2022 in Others by Kithuzzz
• 38,010 points
718 views

1 answer to this question.

0 votes

The final formula is:

 =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel!$B$3:$B$150,AGGREGATE(15,3,(Personnel!$A$3:$A$150='Screen Display'!$I$3)/(Personnel!$A$3:$A$150='Screen Display'!$I$3)*(ROW(Personnel!$A$3:$A$150)-ROW(Personnel!$A$2)),ROWS($H$3:H3))),"")
answered Nov 25, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

It appears happier if you get a ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,420 points
255 views
0 votes
1 answer
0 votes
1 answer

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

answered Jan 29, 2023 in Others by narikkadan
• 63,420 points
218 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,164 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,393 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
686 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,266 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 63,420 points
1,756 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
501 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