• 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

    Find Max OFF Name for Each deal

    Thanks Narayank, it worked.
  2. P

    Find Max OFF Name for Each deal

    In the attached file I want to get OFF Name which has max contribution in a specific deal.
  3. P

    Highlight Text within bracket to Red

    Hello Faseeh, I think, I got it. Sub test() Dim Text As String Dim Index1 As Long Dim Index2 As Long Dim i As Integer For i = 1 To 100 Text = Cells(i, 3).Text Index2 = 1 Do Index1 = InStr(Index2, Text, "(") If Index1 = 0 Then Exit Do...
  4. P

    Highlight Text within bracket to Red

    Hello Faseesh, Not working here. Run time error coming at Text = Target.Text Let me know if you have an alternative method or code
  5. P

    Highlight Text within bracket to Red

    Hello Faseeh, Thank you for your prompt response. But this is useful only when I am manually adding text and brackets in a cell. My problem is I am copy pasting information from multiples sheet to a summary tab. Where I want to highlight text / number within bracket. I hope I am making...
  6. P

    Highlight Text within bracket to Red

    Hello All, I need your help to create / Find any code which can turn any text / Number within bracket to Red. Ex. I have emails copied to (Turn me Red): Email Owners (Turn me Red) Name Excel - Move (Turn me Red) Data In A Cell (Turn me Red) To Another Cell Remove Text With (Turn me Red)...
  7. P

    Transpose column to row basis column heading

    Hi All, Attached file has two tabs (Raw Data & OutCome). What I am trying to achieve is transposing column F & G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab. If in the list we have more than open person with similar...
  8. P

    Sum range using vba

    Hi Smallman, I need VBA because, the above code is a part of big program used for calculating various forecast and pipeline. Hence the formula doesn't work as the program itself insert the column between D & E. Now since I don't know how to tweak the code, need help in this regard.
  9. P

    Sum range using vba

    I have the following code, which was working fine until now. The problems which I am facing is due to the change in condition. Now I'm required to add a column between D & E due to which my formula (Fm1 should change from "D7-E7" to "D7-F7"). Need you help to automate this, the code should...
  10. P

    Switch between files using code

    Thanks Narayan! it is working fine.
  11. P

    Switch between files using code

    Hi All, I am working with three workbooks. My aim is to open two workbooks from cell values provided in my first workbook. Alternatively activate workbook 2 and workbook 3 to copy paste data from wb2 to wb3. I am using the below code but not able to do that. Please let me know what am I...
  12. P

    VBA code to highlight cell based on certain text or date

    It's working fine, Thanks a ton Narayan
  13. P

    VBA code to highlight cell based on certain text or date

    Hi Narayan, First and foremost, Thanks for looking into the problem. Now the back to your concerns. Row 2 is following the logic, If you see the dates in F2, G2 and K2 are from 2013 followed by NA until cell R2 where a future date coming. Hence till that point all cells are green and Pink...
  14. P

    VBA code to highlight cell based on certain text or date

    Hello Hui, I tried doing that, but the desired output is not coming. Hence posted onto the forum. Please help!
  15. P

    VBA code to highlight cell based on certain text or date

    Hello All, Attached file has sample data in sheet 1 and desired output in another sheet. I need to color cell based on certain conditions; If date in the row is less than or equal to today, It should change color of all the cell prior to it as Green. Example Cell O3 has today's date. All...
  16. P

    conditional formatting for deadlines

    D2<C2 format this as green =(D2-2)=C2 format this as yellow Your third condition is similar to the first one. Please confirm if this is what you wanted to ask.
  17. P

    Variance (percentage) between two negative numbers

    I believe your formula should be as follows: Variance = (Actual-Projected)/Actual (-2888-(-2241))/-2888 = 22% Let me know if you need any clarification on this.
  18. P

    COUNTIFS with OR

    Nice Solution Luke!
  19. P

    COUNTIFS with OR

    Luke I am trying to start a new topic but not being able to do so. can you help me find the error in this code. Sub FillInternetForm() Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate "http://www.cvent.com/RFP/NewSupplierRequest.aspx? vtt=1"...
  20. P

    Countif Query

    Thanks Luke!
  21. P

    Countif Query

    Hi I am applying COUNTIF(range,) without any criteria to a range which has reference to other cells in the sheet. Why this formuala is counting only cells where I have 0 in my range?
  22. P

    Conditional Averageif

    Thanx guys for your help!
  23. P

    Conditional Averageif

    Hi Experts, I need your help to find conditional average for my data. Here is link to the file http://kvisit.com/SyIu7AQ , I am looking to find the average of column3 based on data from column1 & column2. Average should be for the month of Feb & June while the for a, b, c and d. Hope I made...
  24. P

    Enter with in a Cell

    Great! Thank you all.
  25. P

    Enter with in a Cell

    I want to give an enter inside a cell containing text. The text inside cell should look like "Prakash is the name of the Person Singh is his middle name Gusain is his last name" All three line inside a cell as they are appearing above. Thanks in advance for looking into this.
Back
Top