Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display Ticket Numbers in Other sheet based on condion
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. |
#2
|
|||
|
|||
Hi Tanveer5389
Perhaps a pivot table, see the attached. Kevin Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i just need to make a sheet for Ticket # and name with who sold i. | Excel Discussion (Misc queries) | |||
Filter / Lookup: Display record on new sheet based on category... | Excel Discussion (Misc queries) | |||
Display diff text based numbers in another cell | Excel Programming | |||
Display numbers in a userform txtfield as numbers with a comma | Excel Programming | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |