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

    Extracting Data with 4 Criteria

    figured out the problem with my data!
  2. P

    Fill in Blank Cell from Cell Above

    DSAshley- Thanks a ton for appreciation!
  3. P

    Fill in Blank Cell from Cell Above

    I assumed that all your data is in column A and then type this in column B, B2: =IF(A2="",A1,A2). Drag the formula till the end of your data and then copy column B and Paste Special as value in column A. Let me know if anything else is needed!
  4. P

    Extracting Data with 4 Criteria

    very strange! C5: =SUMPRODUCT(('Raw Data'!$A$4:$A$19=Summary!$C$2)*('Raw Data'!$B$4:$B$19=Summary!$B5)*('Raw Data'!$C$4:$C$19=Summary!C$4),(OFFSET('Raw Data'!$C$4:$C$19,,INDEX('Raw Data'!$D$3:$P$3,,Summary!$E$2)))) is given is C5; =0 Hui or Busymanjohn can you give any reason for this? I...
  5. P

    Extracting Data with 4 Criteria

    What happened to the first drop down in the sheet? What's it's significance?
View older results
Back
Top