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

Recent content by basavarajkh

  1. B

    Countifs formula for >18 -

    Hi Please find Link below http://speedy.sh/TcMrR/Greater-than-18-Hrs-Less-than-24-Hrs.xlsx help me to write Countifs formula for >18 - < 24 Hrs in cell B4 > Sheet "UPC Pend". Thanks in Advance Regards Basavaraj K H
  2. B

    Countifs with Wild Card

    Thank you lot I edit your formula like below =COUNTIFS(Status!E2:E758,"*" & "HD PVR" & "*",Status!$H$2:$H$758,A4) now it's fine
  3. B

    Countifs with Wild Card

    Hi Please tell me anyone How do I write countifs formula by using wild cards The cell contain "HD PVR" Please find attached Links http://speedy.sh/c8tTs/HD-PVR.xlsx I have to write formula in cell B4 > count the number cell contan "HD PVR" in column E > in Status Sheet belongs to...
  4. B

    How do I Sort Less than Rs. 200.00 Recharge

    I understood but How you Remove "Rs." Please explain me
  5. B

    How do I Sort Less than Rs. 200.00 Recharge

    please explain me how you did?
  6. B

    How do I Sort Less than Rs. 200.00 Recharge

    Hi How do I Sort Less than Rs. 200.00 Recharge Please find link below http://speedy.sh/7fJSt/Sort-Less-than-200-Rs-Recharge.xlsx in column G pls help me Thanks in advance
  7. B

    Countifs or ...............................

    Hi Please find Link below http://speedy.sh/eJ3Da/48-Hrs-Count-of-ASM.xlsx I have to write formula in cell B2 i.e., total no. of w/o (#N/A + Non#N/A) belongs to dhananjaya in AL column (ASM) >Ageing Sheet. & in cell C2 i.e., count of "#N/A" in column AJ belongs Dhananjaya in AL column...
  8. B

    concatenate date cells with text cells, some comma missing

    Hi I have some date in column A, & I already concatenate A1 & B1 with below formula =TEXT(A2,"dd/mm")&" "&B2 & in cell C3 comma is missing please help me to write formula. Pls Find Link below http://speedy.sh/ZqPWc/ex.xlsx Thanks in Advance
  9. B

    Calculated Field in Pivot Table

    Hi How do I put the formula in the Calculated field Ex:- =C6/D6 i.e. = 'Slab / 'Grand Total' Please find the link http://speedy.sh/hPg6P/Copy-of-RT-Performance-March.xlsx
  10. B

    Date format

    Hi In column G some of the date formula not working Pls help me & find the link below : http://speedy.sh/yZYbx/W-O-Pending-for-Closure-1st-March.xlsx Thanks Regards Basavaraj K H
  11. B

    How to find Duplicates between Sub Id Dates

    Pls find the attachment http://speedy.sh/w6duf/Find-the-Duplicates-between-Sub-Id-Dates.xls
  12. B

    How to find Duplicates between Sub Id Dates

    Hi In Column A I have to find duplicates, in that duplicates I want know about both dates are same or not, how to find? Pls help me. Thanks Basavaraj K H
  13. B

    IF .......

    Thank U so much I edited your formula like below =IF(Q11=COUNTA(Comp!A:A)-1,"Y ","N ")&IF(Q14=COUNTA('Pending 1'!A:A)-1,"Y ","N ")&IF(Q17=COUNTA(Created!A:A)-1,"Y ","N ") is'it ok, but I want direct reference, I mean instead of cell Q11, D34+D74. Q14, G34+G74. Q17, I34+I74. I wait for...
  14. B

    IF .......

    Pls find the Download Link http://speedy.sh/xXsgF/TGT-Vs-ACH..xls
  15. B

    IF .......

    Pls find the Download Link http://speedy.sh/xXsgF/TGT-Vs-ACH..xls Thanks in Advance Regards Basavaraj K H
See more
Back
Top