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

    Only counting cells when different from a reference cell?

    Hi Narayan, Thanks for taking the time to explain your formula in such detail. It all makes sense now seeing it broken down like that. Have a good day, Regards, Mark
  2. A

    Only counting cells when different from a reference cell?

    Dear Narayan, Apologies for the confusion - but you have deciphered what I mean/want correctly :) The formula works really well - thanks. Could expand what the '--' part of the formula means? I've never seen this used before. Best wishes, Mark
  3. A

    Only counting cells when different from a reference cell?

    Dear Narayan, My worksheet still continues to evolve.... I'm trying to complete another countif style formula. Specifically I would like to count the number of differences contained within a given clone (I expect it is easier to describe by looking at the attached file). I've attempted to...
  4. A

    Only counting cells when different from a reference cell?

    Dear Narayan, Thanks once again for all your help - your fix(es) works really well. Best wishes, Mark
  5. A

    Only counting cells when different from a reference cell?

    Hi Narayan I've now attempted to use the formula you suggested: =IF($U7=D$5,"",COUNTIF(D$7:$26,$U7)) And it works perfectly providing me with the information that I need - which is great. That siad, I was just wondering if it was possible to tweak the formula slightly..... Specifically...
  6. A

    Only counting cells when different from a reference cell?

    Dear Narayan, Perfect - very elegant!! Thank you for your input in this - it's very much appreciated. Have a great weekend. Regards, Mark
  7. A

    Only counting cells when different from a reference cell?

    Hi Narayan, Sorry for the confusion. :oops: You're absolutely right - what I actually want is to know how many times one of the 20 alternative amino acids appears at a given position in the reference amino acid sequence. (Actually I suppose that should be 19 alternative amino acids to...
  8. A

    Only counting cells when different from a reference cell?

    Dear Narayan, Thanks for your reply. In answer to your question the clones sequences listed in V4:V23 are, to all sense and purposes, cut and pasted from an output file generated by an amino acid/protein sequence analysis programme. All clone sequences are going to be the same length (i.e 16...
  9. A

    Only counting cells when different from a reference cell?

    Dear Sajan, Thanks once again for your reply and advice - it's very much appreciated :) I've (hopefully) attached a spreadsheet with a typical data set that should make things a little clearer/specific.... Specifically what I'm trying to do is compare a reference range (protein amino acid...
  10. A

    Only counting cells when different from a reference cell?

    Thanks to Sajan for his quick reply :) Just to up the ante a bit. Is it possible to take Sajan's formula: =Countif(B1:F1,"<>"&A1) and combine it with another.... In an ideal world I'd like to ask more about those cells in my data that do not match my reference sequence. For example is it...
  11. A

    Only counting cells when different from a reference cell?

    Hi Sajan, That's fantastic!! Thanks for taking the time to reply. Best wishes, Mark
  12. A

    Only counting cells when different from a reference cell?

    Hi I am attempting a relatively simple task but I’m struggling, and was hoping that someone might have some advice. Specifically: I would like to count how many times a cell in my data range is NOT the same as my reference cell. I have a reference cell and a non-numerical data range. For...
  13. A

    Autofill column or rows with gaps

    Thanks Narayank991 Thanks for taking the time to reply to my post. Have a good day, Regards, Mark
  14. A

    Autofill column or rows with gaps

    Hi, I was wondering if it is possible to fill a column or row increasing in number but with the twist that I want to miss a column or row out. For Example: 1 (miss a column) 2 (miss a column) 3 (miss a column) 4 etc Normally I would type 1 in a cell then holding down Ctrl pull the cell...
  15. A

    An alternative to COUNTIF function?

    Hi Faseeh, Thanks for taking the time to help me out. I'll give it a go and get back to you, Best wishes, Mark
  16. A

    An alternative to COUNTIF function?

    Good Morning Excelees and Excelettes, I have a column (C) that contains the outcome of a simple COUNTIF function: =COUNTIF($A$1:$A$6000,B1) Where A1:A6000 is my range and B1 is my criteria. The output will either be a 0 (criteria not in range) or 1 (criteria present in my range; criteria...
  17. A

    Conditional format of cell range using Formula is condition

    Thanks Hui & SirJB7. Regards, Mark
  18. A

    Conditional format of cell range using Formula is condition

    Hi Hui, Thanks again for your help in this. The formulas you suggest work great. To satisfy my curiosity what does the '&#62;0' part of the formula do/define. Thanks Mark
  19. A

    Conditional format of cell range using Formula is condition

    Good morning Hui, Apologies for not replying sooner, but I posted the question and then took myself off to catch up on some [much needed] beauty sleep! I like the idea of using the feeder cell and MATCH combinations that you described above; it will certainly be quicker than how I'm doing...
  20. A

    Conditional format of cell range using Formula is condition

    Good evening Ninjas, Hopefully there should be a simple answer to this: I have a collection of cells (A1:E16) containing single letter values corresponding to different amino acids (A, T, M, G, K etc). I want to conditional format the 21 different characters according to two different...
  21. A

    CHAR( ) command problem

    Hi Narayank991, Thanks for your message. Replaced the 109 with 181 and voila: all good :o) Thanks for your help, Best wishes, Mark
  22. A

    CHAR( ) command problem

    Hi everyone, Hopefully there should be a quick answer to this: I want to include the micron symbol in the following text based formula: ="The concentration of your sample is"&(A1)&" "&CHAR(109)&"M" Where A1 is a user defined value Specifically, I'm trying to use the CHAR() command in...
  23. A

    Autofill along rows with a mouse click

    Good morning SirJB7 & Hui, Once again thanks for your help with this question. @SirJB7 All good suggestions both of which I'm pleased to say I currently do. The beauty of the vertical autofill I highlighted in my original post is that it works really well when you have a large number of...
  24. A

    96 Cell Grid Transformation with label

    Hi SirJB7, Thanks - it was a bit touch and go for a while - but we came good in the end. I'm going to take what I've learnt and apply it to some of my data. There's a few things I'm thinking of adding to the pot....but I'm going to give it a go myself - so expect more questions in a couple...
  25. A

    Autofill along rows with a mouse click

    Good evening - should be a quick answer to this.... I stumbled across the genius short cut of clicking on the small box in the bottom right hand side of a highlighted cell to autofill downwards in a column http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/ Made me think if there was a...
Back
Top