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

    IF statements OR

    It has worked perfectly and does exactly what I needed - thank you
  2. E

    IF statements OR

    Thank you I will try the above. Is this called a nested IF function?
  3. E

    IF statements OR

    Hello I have a worksheet that I want to add a formula to which will project dates based on a wording in a particular column. So I have =IF(B2="One week",A2+7) or =IF(B2="Two weeks",A2+14) or if B2="One Month" then =EDATE(A2,1) or if B2="Three Months" then =EDATE(A2,3) How can I include all...
  4. E

    Splitting

    Thank you AlanSidman, I am in the process of creating a spreadsheet to show what I am trying to achieve... I will repost later today...
  5. E

    Splitting

    Hello I have a project where I receive sheets from many different departments and need to be able to split each sheet up by a category and then copy that entire row entry across to a master sheet that adds in effect collates the information for that category.... I have found some VBA online, but...
  6. E

    Dynamic Named Ranges

    When I downloaded and opened it it showed the correct count (51) but when I then enable editing (as it displays protected view, that number changes to 1 (1)... Not sure what I have done wrong here????
  7. E

    Dynamic Named Ranges

    Thank you I will take a look now :-)
  8. E

    Dynamic Named Ranges

    Hi - I posted yesterday regarding named ranges and was kindly informed of index or offset to make a named range dynamic. However I cant seem to grasp how to make these work within other functions. I have attached a sheet and am trying to create a dynamic range (that will adjust when rows are...
  9. E

    Named Ranges and Shared Workbooks

    I can’t seem to make these do what I need them to do - I know it’s me!! I have attached a sheet and wonder if someone can show me what I’m doing wrong... I need a range that changes as rows are added (index or offset) and a return count of unique numbers in the column. I did this when I had a...
  10. E

    Named Ranges and Shared Workbooks

    Thanks you so much - I will have a look at the links
  11. E

    Named Ranges and Shared Workbooks

    Hello I had successfully created a 'dashboard' using a datasheet formatted as a table, but when sharing the workbook in the review tab, it says that sharing does not support a table and to convert to named ranges. I have now converted the table named ranges (which allows the sharing of the...
  12. E

    I have a countif question

    Didn I know! Funny thing is now I put an additional row into the worksheet it is working as I set it up - thank you !
  13. E

    I have a countif question

    thanks i will try this and report back :-)
  14. E

    I have a countif question

    Hi I have one horizontal countif ... =COUNTIF(D6:Z6,"*") bringing back a count and I want to capture the resulting cell return that is greater than 0 in a vertical countif - I have used =COUNTIF(C6:C96,">0") but it keeps coming back with 0. This does not seem to want to work on Excel 2016...
  15. E

    How do I return a Yes or No response?

    Thank you Hui that’s worked perfectly! And to AliGW too !
  16. E

    How do I return a Yes or No response?

    Hello I tried it but it only brings back no even when there is something in one of the cells ? What should I be putting in the criterion part? =IF(COUNTIF(A1:T1,criterion)>0,”Yes”,”No”)
  17. E

    How do I return a Yes or No response?

    Thank you I will try this out
  18. E

    How do I return a Yes or No response?

    I want to look across a row of cells and if any one of them has some data in to cell it returns a yes or no return .. . I am using counting to count how many cells have something in, but I want another return that doesn’t count ... many thanks
  19. E

    convert matrix to list

    Hi Is there an easy way to convert a matrix type table into a list in Excel? I have uploaded an example worksheet. The yellow shaded section is the matrix and the blue shaded section is the list I would like to achieve. I think it may be VBA if anything??? many thanks for any help.
  20. E

    12 months rolling trend.

    Narayan. Will this work if some months have zero data? It doesn't seem to allow expon. trend lines when there is zero in my data :-/
  21. E

    12 months rolling trend.

    Narayan. Wow that looks great. I have 22 others to do, but that is exactly what I need to show. Thank you
  22. E

    12 months rolling trend.

    Hi Vletm - I don't think I am explaining myself too well. I only want one arrow based on a 12 month period of data, not one for every month.. Thank you for your help though...
  23. E

    12 months rolling trend.

    Hello and thanks for your reply :-) I have added my file now. Would you be able to have a look at what I've done? I wanted to use arrows to indicate the trend for rolling 12 months i.e up, down or the same...
  24. E

    12 months rolling trend.

    Hello all I have some data across 12 months Jan to Dec. I have created a short trend (month on month) using IF and wingdings characters to show 'up' 'down' or 'no change'. I would have used sparklines, but they dont display a trend line :-( BUT I need to show the longer term trend over the...
  25. E

    Valid list and lookup

    Hello clever Excellers.. I have attached a file that has two pages one being the main table and the other being some data I want to use to populate the main table. I had created a valid list on the main sheet that used the months from the other data table to then fill in two cells one showing...
Back
Top