Display Ticket Numbers in Other sheet based on condion

[Tanveer5389]

Hello All,

I'm very new to excel advanced formulas. I need a help from you all hop
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. Jus
want to display the Ticket numbers in "Formulated Data" sheet based o
priority.

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

Please please please help me

+-------------------------------------------------------------------
|Filename: Sample Data.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=746
+-------------------------------------------------------------------

 

[Kevin@Radstock]

Hi Tanveer5389

Perhaps a pivot table, see the attached.

Kevin

Hello All,

I'm very new to excel advanced formulas. I need a help from you all hop
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. Jus
want to display the Ticket numbers in "Formulated Data" sheet based o
priority.

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

Please please please help me

+-------------------------------------------------------------------
|Filename: 003-Sample Data.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=747
+-------------------------------------------------------------------