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 909 views

## 1 answer to this question.

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))),"")`
• 63,720 points

## 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

## 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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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