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

    Formula to populate symbol if zero repeated continiously for particular row

    Hi I have 60 columns. in the 61th column, I want to display bar symbol (-) if the cell for each row contain zero continuously. Is there any formula. Plz help me. for row2 , suppose the column ap,aq and ar contain zero and rest cell contain other value. so for that particular row, i want to...
  2. A

    VBA

    thanks narayan
  3. A

    VBA

    thanks narayan, its working very fine. But the string 'Cases' has not been added to the numeric data. Output should be like this. Could you plz spend some time. Your help will be highly appreciated Boys mark Physics=50 Cases Boys mark non-Physics=1 Case Boys games in Physics=11 Cases Boys...
  4. A

    VBA

    The macro removes cases where equal to zero(=0) is there along with string "No Cases". Can we restrict that it works where value (=0) is there but skip records with string "No Cases".
  5. A

    VBA

    thanks narayan, its working properly
  6. A

    Vba small help

    thanks Hui, its working fine now.
  7. A

    Vba small help

    Hi, i want to run the macro from row number R7 upto R200 as R1-R6 is having data. dim i as range Set i= Range("H7:h200").SpecialCells(xlConstants) But sometimes data are not available from starting row(R7) but when I run the loop, I am getting error "no cells found". What condition i need...
  8. A

    VBA to count multiple record value to one value in single record

    thanks narayan for looking the matter. Yes, every line consists of 4 parts.If string on any one of the part is duplicated, then we need to take only one.
  9. A

    VBA to count multiple record value to one value in single record

    hi all, I want to count the below records to two single records (based on cts and ibm). Each string should repeated only once finance/economy/boy/cts=12 finance/economy/girl/cts=3 finance/economy/boy/cts=6 education/economy/boy/cts=2 commerce/non-economy/girl/cts=3...
  10. A

    Range issue in excel

    Hi, I want to convert following range value to formula but getting error. can anybody help me; · very common 10%, · common 1% to < 10%; · uncommon 0.1% to < 1%; · rare 0.01% to < 0.1%; · very rare < 0.01%. =IF(M10<"0.01%", "very rare" , IF(AND(M5>=0.01%...
  11. A

    fill color and border in dynamic range

    Dear FASEEH Whether we can write macro to do that.
  12. A

    All border using VB macro

    thanks Wookiee Its working now
  13. A

    All border using VB macro

    One problem here is that the macro is restricted to row only, where as border are selected for all column. I dont want border whereever I come across blank cell in rows or columns
  14. A

    All border using VB macro

    thanks a lot Wookiee
  15. A

    All border using VB macro

    Dear all, In my datasheet, I have four variables. I need to make all border from cell(2,2) to last row along with last column until I encounter blank row and column. Pat_id Serio BODY_SYS PREF_TERM Pat_001 Ser Skin and subcutaneous tissue disorders...
Back
Top