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

    Multiple activites - Convert format - delete all rows above the table- change tab name to: X

    i just wanted to add that it is not a real table - just noted that -
  2. D

    Multiple activites - Convert format - delete all rows above the table- change tab name to: X

    Hello 1. I have a mutiople files in a network folder. I required the folowing steps to work for ALL files in aspecified folder. This save me doing the below step to 100s of files manually. 1. To change the format of each file from .htm to .xlsx. 2. To remove the delete all rows above the table...
  3. D

    need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

    Look at the attachment - I just want to know if there a quick way to change the text within the cells it looks presentabl e - thanks
  4. D

    need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

    I do not understnad. I need to manually go to the cell and go the end of each sentnce and press delete to change the sentence to a nice format. I need help for that please. Maybe space space is not the correct word - but need help to prevent me doing manaually.
  5. D

    need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

    Please refer to sample attached exel - bad formatting F6 - Fixed G6 I would like a macro to fix - so I can run on hudreds of cells, and save me ma naually fixing. All the macro so far do not fix my issue. thanks
  6. D

    need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

    Hi I need a macro that will remove unwanted spaces for there is a space of 1 between each word. Bad "3.1.13 In addition to obtaining customer approval, application service requests for configuration changes submitted by Managed Service Providers (MSP) are approved by a Customer Adoption Team...
  7. D

    how to identify columns - start and end

    i am confused.. sorry i just waned to countam amazing - does the job and easy to undesttand - great job!!!!
  8. D

    how to identify columns - start and end

    it does not - sorry it gives 25 always even if cells are blank any help will be much appreciated so it only takes those cells that are populated and not blank
  9. D

    how to identify columns - start and end

    It alway gives me 25 do not see how it counting the items in each column?
  10. D

    how to identify columns - start and end

    hi hi I want the below to combine data from columns A to L - how do I hammend the below to do so? thanks - >>> use code - tags <<< Sub k() Dim oneColumnHead As Range Dim columnHeads As Range With ThisWorkbook.Sheets("shee") Set columnHeads = Range(.Cells(2, 8), .Cells(1...
  11. D

    testing period dates ([un/]solved)

    i have 365 office trying
  12. D

    testing period dates ([un/]solved)

    Hi I have a table that show testing pass / fail and the dates - there are many rows. Each rows is assigned a number (test scenario) and a test scenario may appear more that once test scenario date completion 1 01/01/2022 1 01/01/2022 1 15/01/2022 2 01/03/2022 2 24/04/2022...
  13. D

    help with modifying an if fomuelae.

    Hi It is not providing the desired results. If I provide you the excel, will it help - the table in on sheet 2 cell L4.
  14. D

    help with modifying an if fomuelae.

    I want to make it so that I do have a test case number on the table if I have not added a test case number of the spreadsheet.
  15. D

    help with modifying an if fomuelae.

    Hi I have =IF(L3=$T$21,$T$20,COUNTIF(Testing_Main!$K$10:$K$147,L3)) I need to add another AND ---- so that it should only add a number in the cell if this is also a number the M column of the row that is beng checked. If there M cell is blank in the row, then it shoud return an empty...
  16. D

    how to prevent user selecting a duplicate value from a drop down list.

    Hi I cant' find this solution anywhere on google. I have a colum where a user select a value from a list. I want the excel to prevent the user from sleecting the same choice twice . tab: Testing_Main - cell: m10, m11,, etc. currently the user could select TEST_1 twice... i need to...
  17. D

    Condiitonal formatting with multiple colours for text based on an if statememt.

    Hi In the excle. - tab:Testing_Main CELL E8 - there is text that updated automatically. I am not sure if this is possble. If the text states: "CONGRATULATIONS!!!!! - ALL CELLS ARE UPDATED" - can the text be green and if the text has any other text - it should be red. if stateemnt cell...
  18. D

    Counting Cells that are red

    Can you help me with the below - show me show to do that? I have no idea
  19. D

    Counting Cells that are red

    Hi Please help me. I tried to google this but I got errors messages I do not understand. I managed with the help of your experts I manged to tcolour cells red - using the conditional formating. I need to count these cells. red now. Range is B10 to P100 AND R10 to R100 The tab is...
  20. D

    conditional formatting help (solved)

    this post is closed now
  21. D

    conditional formatting help (solved)

    GENUIS!!!! thank you - - you saved me doing one by one.... what a relief.
Back
Top