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

    Highlight row based on date and a spesific content in one cell

    I have a spreadsheet with a status column and a date column. Status can be 1 = Finished and 2 = Outstanding I'm looking for a way to highlight the row where the status is 2 and the date is overdue. It looks like this: Id Name Action Status Due Date 1 Peter 1 10.03.2024 2 Alex 2...
  2. S

    Problems with chart

    I have a spreadsheet where I like to put in astacked bar. The chart shows Completed and Outstanding cases. I want it to show the number of completed to the left and Outstanding to the right. In that way the bar will grow to the right as the tasks will be complete. I have attached a sample...
  3. S

    Problems with IF formula with 4 IFs

    I have a column A with four different status descriptions. I want to convert this in to a number for each code. Accepted = 1 Accepted with comments = 2 Not accepted, revise and resubmit = 3 For information only =4 I have tried this formula: '=IF(A2="Accepted";"1";IF(A2="Accepted with...
  4. S

    Need help to create curves showing plan and progress

    I have a spreadsheet with documents showing dates for planed issue, actually issued, rejected or approved. I want to create a chart showing the exact number of documents in each status on a timeline. I have attached an example file with a picture of a chart looking like the one I'm trying to...
  5. S

    Highlight Entire Row using Conditional Formatting with two conditions

    Can anyone help me create a conditional formatting based on two different conditions? I have a spreadsheet Where I have one column for Status and one for the date of reply. I have made some conditional formatting's that colors the row red if Status is 2, and green if status is 1 or 4. What I'm...
  6. S

    How to show only the last

    I have a report from an external system showing a long list of documents. List shows document numbers, title revision and so on. Looking like this Document Number Revision Issue reason Status Title 10003276804 1 Issued for CR 2 GENERAL ARRANGEMENT 10003276804 2 Re-issued CR 2 GENERAL...
  7. S

    Report by month based on date

    I have a spreadsheet with two different date columns. One for started date and one for closed date. The tate format is dd.mm.yyyy In order to report how many cases that was opened and closed each month I need a way to do this. I was planning to add a new columnd next to the date columns and...
  8. S

    Custom cell formating

    I'm putting in information from into Excel. All lines are numbered in chapeter numbers that is important to keep. 14.1.0 14.1.1 14.1.2 14.2.0 14.2.1 How can I keep this format in excel? Problem now is that it changes it to date.
  9. S

    Help with IF formula

    I have two columns containing dates. I'm trying to write a formula in a third column returning an X if the date in B is larger than the date in A. If date A is bigger or like B i want the cell to be blank. IF A1=B1 leave blank IF A1>B1 leave blank If A1<B1 return an X
  10. S

    Convert Letter to number

    I have a spreadsheet with one coumn contaoing drawing revision. This can be either number or letters. I want to create a new column where the revision letter is changed to a number. A=1, B=2 ... Where the revision is a number I want the new coumn to leave the cell empty. Anyone who can help?
  11. S

    Button to turn on an off diferent filters

    Is it possible to make a button with a macro ore something that turns on a filter? I have some filters that I would like to assign to a button. And allso a button that turns off all the filters. Can anyone guide me in that?
  12. S

    Changing range in Dynamic Filter

    I need to filter my listings in Excel to show only elements with due date the next two weeks. I find next week and next month in the dynamic filtering. Is it possible to change that to next two weeks (or 14 days)? How can I manage to change that?
  13. S

    Is it possible to create a bar chart showing planed amount and a bar overlappig

    I have a simple tabel in Excel Total 140 Completed 100 Rest 40 I want to create a line showing the total number(140) with a new line inside showing the number of completed tasks. My idea is to have a long bar in one colour showing the total number of tasks and one bar in...
  14. S

    Excel chart published to web, how to cancel that operation?

    I have a spreadsheet where the chart is saved as a Singel File Web page and published on a Share Point Site. Now I want to turn of that function but can't find out how to.
  15. S

    Excel chart greates multiple images and slows dow the program

    I have a spreadsheet with a s-curve on a seperat tab. Problem is that every time the file is saved it creates a new image of the curve. And now it is so many that the spreadsheet chrashes every time I try to do something. When i select the graph area it says "Picture 734" Does I realy have 734...
  16. S

    Date input

    I use the numpad for inserting dates in excel. I find it annoying that Icant use the , key but have to use the . key instead. i I use the input format dd.mm.yyyy if I use dd,mm,yyyy excel doesn't reckognise it as a date. Any sugestions? Is that something thaty can be fixed in excel?
  17. S

    Calculate overdue days

    I have two cells with dates and want excel to calculate how many days overdue i am in my woorkload. Eksample: A1 contains the start date B1 next due date C1 I want to show how many days I'm overdue. I have managed to shov the number of days by useing this formula...
Back
Top