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

    Returning multiple rows of data in one cell

    Hi :) Thanks for your answer, but neither of those forumla seems to work on my spreadsheet unfortunately. The first formula returns them all in one line with no spaces and the second formula comes up with #NAME?. I worked it out in the end and came up with...
  2. R

    Returning multiple rows of data in one cell

    Hi Chandoo :) I have a large spreadsheet which holds all my client data and i want to link it to another spreadsheet to turn it into more of a report. worksheet 1 - called "Formatted" Worksheet 2 - Called "list 2012" in "Formatted", columns L to P are entitled "Address 1", "address2"...
  3. R

    conditional formatting whilst comparing column data

    You're a genius :) Thank you ever so much!! :)
  4. R

    conditional formatting whilst comparing column data

    I've just tried those formulae, (thanks very much btw, haven't used the AND function before)... but it's still showing the empty cells as green :( I'm sorry to be a pain, but how would the =ISBLANK(A2)=TRUE formula work which you suggested earlier? would i combine that with the 'better'...
  5. R

    conditional formatting whilst comparing column data

    Hi Luke, Sorry, i'm not sure what you mean... do you mean put all three CF entries in for 'better', 'worse' and 'equal' as above and then enter a fourth CF criteria? I only have three conditions available in the CF box and have never tried vba or macros, (am a bit scared of them)so if there is...
  6. R

    conditional formatting whilst comparing column data

    Thanks Luke, that's really helped - I've now got the problem that the cells which don't have any entry in column B (some of the students didn't take certain subjects) are all showing as red, even though there are no entries. Is there any way to tell the spreadsheet to only account for the...
  7. R

    conditional formatting whilst comparing column data

    hi... i hope someone can help with this, but i've got a spreadsheet where i have predicted gardes in column A, and actual grades in column b... i need to highlight where column B differs from column A, for example: Pred.grade in A2="d", actual grade in B2="f". i would like cell B2 to show as...
  8. R

    How do i calculate using varying criteria?

    Hi there... new to this, but i have an excel question that no-one seems to have an answer for and i'm hoping you can help? I've got a large spreadsheet, containing information on project leads i'm chasing, for two separate offices. I differentiate between the two offices in column A by noting...
Back
Top