• 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 nishant859@yahoo.co.in

  1. N

    VBA code for deleting rows, using Name

    Need a help, I need a VBA code for deleting rows from the table in Sheet Temp excluding status mention in Sheet Select Status Mention in Sheet Select may change time to time (may increase or decrease also), so i was trying to use Name function, but unable to do so
  2. N

    VBA code required for deleting Row, using Name function

    Need a help, I need a VBA code for deleting rows from the table in Sheet Temp excluding status mention in Sheet Select Status Mention in Sheet Select may change time to time (may increase or decrease also), so i was trying to use Name function, but unable to do SO Duplicate...
  3. N

    Replace text between two text references within existing string

    ok, i missed "in english" word
  4. N

    Replace text between two text references within existing string

    What is this " HALLAR " & " EXTRAE " Could not found them in excel function list
  5. N

    Getting a concatenated text list of applicable values

    =CONCATENATE(IF(B2<>"",B$1&",",""),IF(C2<>"",C$1&",",""),IF(D2<>"",D$1&",",""),IF(E2<>"",E$1&",","")) or you can use equal (=) sign with your value
  6. N

    Payroll Calculation

    Thanks Faseeh for clearing my doubt
  7. N

    Payroll Calculation

    I think need correction in Lunch 0.30MM it should be Lunch 0.30 pm
  8. N

    Count rows highlighted in red color

    Thanks Hui, That means we use VBA commands in Name Manager as a Formula
  9. N

    Count rows highlighted in red color

    Thanks Debraj, working fine but what is GET.CELL Could not found this function in excel
  10. N

    Create custom groups in a pivot table

    Please upload your file or try using Home -> Insert -> Insert Calculation Field -> (Than Create you Formula as per Requirement)
  11. N

    Count rows highlighted in red color

    Even, I don't know VBA I am afraid from Programming since my college days
  12. N

    Count rows highlighted in red color

    Thanks for you reply, but i can't use VBA in my sheet because the person who will use this sheet neither know excel nor VBA & this red color are manually filled by team member Thanks again
  13. N

    Count data from single column with different condition

    Hi All, I want to Count Data from a single column say F with multiple condition like all the cell equal to either "suspected fraud" or "fraud" or "fraud booking" or "fraud location" or "previous fraud" using multiple condition with data also like how many above mentioned type of frauds we...
  14. N

    Count rows highlighted in red color

    We have a Data in Column A,B,C,D,E,F I want to Count rows, that are highlighted in Red Colour without VBA
  15. N

    Changing Data In Worksheet1 - automatically changes data in Worksheet2

    Try below mention formulas in "Subtotal by Project" worksheet in cell H6 & I6 respective =IF(RIGHT($B6,5)="Total",SUMIF($B7:$B206,LEFT($B6,LEN($B6)-6),H7:H187),INDEX(Table1[Column8],MATCH($B7&$C7&$D7,Table1[Column2]&Table1[Column3]&Table1[Column4],0),1))...
See more
Back
Top