Search results

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

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

Hi, My previous two posts were answered successfully within minutes :o) so I thought I'd push my luck and throw another question out there. Being a scientist a lot of the data that I have to analyse comes back in the form of multiple Excel 8 x 12 cell grids. There are 8 rows (A - H) and...

Hi, Would someone be able to tell me if it's possible to search previous posts contained within the Chandoo forum? In this way I can avoid repeating a question that has been asked [multiple times] before. Thanks for an excellent, amiable and well run site, Regards, Mark (Austinma)

Hi Excel Ninjas Straight off the back of my inaugural post yesterday I thought I'd come back with another question.... I have two sets of data pertaining to the same unique identifiers (names). For example First Data set 1 C1 C2 Mark Red John Yellow Mike Green Steve Blue and Data...

Hi I can easily define the following formula by typing the text and dragging the cursor over the range of cells that I want to select: =SUM(A1:A20) If I wanted to fix the range to give the following formula: =SUM($A$1:$A$20) Then I would have do to manually type the '$' signs on either...