• 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. 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))...
  16. N

    Data Extraction from Worksheet1 (ws1) for Worksheet2 (ws2)

    But Vlookup returns only the first value from ws1, like for Brand A,vlookup return product 1, but i want both 1 & 4 && how could i shorten my name
  17. N

    Data Extraction from Worksheet1 (ws1) for Worksheet2 (ws2)

    My Query is:- I have Raw Data in ws1, now I want to extract some required data without using pivot table & VBA in ws2 Data in ws1 Brand (InCell A1) Product (In Cell B1) a 1 b 2 c 3 a 4 b...
  18. N

    Changing Data In Worksheet1 - automatically changes data in Worksheet2

    You can use vlookup or index with match function or data link method to do or pls share the sample data
  19. N

    Decrease file size without removing conditional formatting

    Save your workbook in a Binary format or use Document Inspector
  20. N

    Excel: Need to move information from hundreds of rows in Column A into Columns

    Use below mention formula in mentioned cells & Drag until you cover your entire data in the format you want here, i assumed blank row in between ((Phone Number 4)) & ((Jane Monroe 1)) In C2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2)),1) In D2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2))+1,1)...
Back
Top