Hello All,

I'm very new to excel advanced formulas. I need a help from you all hope you will be able to help.

I hav attached an excel document in which there are two sheets.

(i) Raw Data
(ii) Formulated Data

In the raw data sheet i have two fields Priority & Incident Number. Just want to display the Ticket numbers in "Formulated Data" sheet based on priority.

Please tell me what formula can be entered to display ticket numbers in "Formulated Data" sheet based on priority.

Please please please help me.