Extract the Ticket Number Basis a Condition

[shyam sundar]

Hi Team,

I am having a worksheet, in which sheet 1 contains a summary of records. From that I need to pull the ticket number alone if "Column D" value as "Post".

Attached a sample file for your reference.

[HansDouwe]

Please empty all cells with expected results and try

Please Login or Register  to view this content.

[jeffreybrown]

If you have 365, something like this could work >> =CHOOSECOLS(FILTER(Sheet1!A2:D7,Sheet1!D2:D7="Post"),2)

[Glenn Kennedy]

Your profile says Excel 2019. If that is still correct, you will need something like this instead:


=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($D$2:$D$16)/($D$2:$D$16="Post"),ROWS(G$2:G2))),"")

copied down.

[shyam sundar]

Thank you all for spending time on this query. It worked thanks again