• 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

    In the attached file I want to get OFF Name which has max contribution in a specific deal.
  2. 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)...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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?
  8. 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...
  9. 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.
  10. P

    Data labels Percentage together

    Hi All, I would like to know is it possible to have data labels & their repective percentage together in column or bar chart. For example 5,10,15 & 20 is my series. I want to show my data label as 5 (10%), 10 (20%), 15 (30%) & 20 (40%) respectively. Thanks in advance for looking into this!
  11. P

    Basic of VBA

    Hi all, I don't know even ABC or VBA, though I want to learn it really quick. Please suggest any website (free) to learn it real quick and easy. Prakash
  12. P

    Good forums to take help in Excel ?

    I remember last time Chandoo started a post mentioning links to some good excel websites. I request you guys to post links to good forums where people discuss Excel (not much of VBA) queries and help each other learn faster. Best! Prakash
  13. P

    Weekday only from column to rows!

    Dear All Experts! I want to populate some data from sheet 1 to sheet 2 but the data is date and in columns of sheet 1. I want to have only weekday (no sunday, saturday) in sheet 2 but in rows. Also there is some time associated with each student each day, I want to show that time as well...
  14. P

    How to Align Data Label

    With reference to http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/ I would like to know, how can I make adjustment for data label in such way that it move with the pie chart? As in this example it is moving with the speedometer hand created using a pie chart. Thanks in Advance!
  15. P

    How to Insert ▲, ● and ▼?

    With reference to http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/ I would like to know how can I insert ▲, ● and ▼ in my cell. I tried searching them in the symbol section but couldn't locate any. Chandoo has talked about some appending, what...
Back
Top