• 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 columns from table

ori

New Member
I have a table with the columns: account number, message type, delivery date 

I would like to get all the rows when the message that was sent is type 0

Ex of table: 

Account number.      Message type.     Delivery date

123.                               3.                        22/1/12

345.                                0.                       23/1/12

345.                                5.                        23/1/12

456.                                4.                        24/1/12

789.                                0.                        25/1/12

986.                               6.                         26/2/12

The result I need: 

345.           0.        23/1/12

345.           5.         23/1/12

789.           0.         25/1/12
 
Ori


Have a look at Lukes Formula here: http://chandoo.org/wp/2011/11/18/formula-forensics-003/
 
Back
Top