• 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.

Search results

  1. V

    Copy Paste Exactly

    When I type "=+'1'!I18" excel opens a file browser window. I don't know why :p
  2. V

    compare two column data and display which is missing

    Use vlookup. Syntax is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) For your problem, the formula is =VLOOKUP(A2,$B$2:$B$4,1,0). To make it much better use =IF(ISNA(VLOOKUP(A2,$B$2:$B$4,1,0)),"match not found","match found") Then filter column B with "match not found"...
  3. V

    Filtering top 20

    Use data filter... select the column row and hit Alt+d,f,f. Then select the material from "Material" column (first select Soap). Then in quantity column select "Sort Largest to Smallest". This will sort the product with maximum quantity from highest to lowest. You can select top 20 from it...
Back
Top