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 in Others by Kithuzzz
• 20,660 points
19 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 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer
0 votes
1 answer

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
39 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 in Others by Edureka
• 13,640 points
142 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 in Others by Edureka
• 13,640 points
240 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 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18 in Others by gaurav
• 22,040 points
71 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 in Others by narikkadan
• 37,660 points
43 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 in Others by narikkadan
• 37,660 points
62 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