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...
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...
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
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...
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...
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...
Hi Hui,
Thanks again for your help in this.
The formulas you suggest work great. To satisfy my curiosity what does the '>0' part of the formula do/define.
Thanks
Mark
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...
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...
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...
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...
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...
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...