excel tricks

I have the below data set when i select the Department I want to get a table wih all the employes working in thhat department like this Only Vlookup formula can be used to obatain the result table. Kindly advise. Thanks for the Help in advance

I have a dataset like below when I select Department from the Dropdown I need to return multiple matches in atable format like below Which Formula can i use to get these multiple matches in a table format....Thanks in advance

How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..

How Hide Row According value is Zero on Pivot tables ??? Condition is zero value to hide table Entry in pivot tables.

Show Result : 3 (Pleased Show this Query........................................)

How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " if Qty balance is "0" , not show entry in report Again.

EX: A1 cell EXP/089/20-21 # i try to find particular word to alert condition # find : /20-21 (this word fount to alert to other cell , "ok","Not"

Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...

Kindly Find Result....in Above Question...

I am trying to get the correct formula to count the number of days it has been for each employee since the last occurrence of an absence/tardy. For each employee, starting with the beginning of the year, we mark and employee as Absent as an "A" or Tardy as "T". See below the examples...