Recent content by Austinma

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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