excel tips

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

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

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

Pleased make this VBA script ...... Find to Zero value on row & hide this row

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.

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

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"

@ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)

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

Hi I have a list of data which i Got from pivot table which is given below and i want those data in different format. Please help Place Name USA John Rohan Alex Roxy India Rahim Sourav Bikram I want previous...

Hi! I have a Form to be filled and i receive the data as .txt files, hence have to convert data from txt to excel format for the ease of copying to my target form easily. Now i have managed to convert the file to excel, but certain formats are really confusing. I would be grateful if someone...

Hello, everyone! I am training myself to be a proficient administrative assistant, and I am looking for some advice from experienced Excel users as to what they believe would be the most useful Excel knowledge for my job level. Many job postings for this type of position require advanced...