• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get custom columns from Filter function

Juniad

Active Member
I have attached sample file where required the 1st,2nd,3rd and 7th Column through Filter function.
 

Attachments

  • Filter coustom columns.xlsx
    10.3 KB · Views: 10
Hi,

Power Query if interested:

Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"File No", type text}, {"Name", type text}, {"Designation", type text}, {"Status", type text}, {"Passed Date", type any}, {"Card Status", type text}, {"Card Received", type text}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"File No", "Name", "Designation", "Card Received"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [Card Received] <> null and [Card Received] <> "")
in
    #"Filtered Rows"

Regards,
 
Using dynamic arrays
= FILTER( Table1[[File No]:[Designation]], Table1[Card Received]<>"" )
= FILTER( Table1[Card Received], Table1[Card Received]<>"" )
 
Back
Top