Search results

I would add columns for all the totals you use: one with the sum of all the holes, one with the last 9, etc. Then just sort the data as needed. Or you could try something like 10000*sum of all holes + 1000*sum of last 9 + 100*sum of last 6 + sum of last 3 + last hole. You will need to adjust...

If the number is in A1 put: ="some text " & A1 & " and some more." in another cell

This line: Range("A4", Range("A4").SpecialCells(xlCellTypeLastCell).Address).Rows.ClearContents is the problem. It clears the whole row. Try something like: Range ("A4", Range("DI" & LastCell)).ClearContents (I haven't checked it)

Or try this in B2: =IF(AND(VLOOKUP(B$1,Sheet1!$B:$C,2,0)<=$A2),VLOOKUP(B$1,Sheet1!$B:$C,2,0)+VLOOKUP(B$1,Sheet1!$B:$D,3,0)>$A2),VLOOKUP(B$1,Sheet1!$B:$E,4,0),0) and copy as needed.

If I understand you correctly, you can make 1 column with a,b,c,d or thing like ab if it is in more than one group. If you then want to filter on group a, select 'Custom' from the drop down list (some where at the top) and choose contains in the top left box and type the group letter in the top...

You could make one row with the data and then two hidden rows with the data as you have it now. Or manually edit the dataseries: for series a select the cell with the data, then hold control and select an empty cell for series b,c,d select the empty cell first, then the cell with the data

Most of the time when I protect a sheet, I do not fill in a password. That means anyone can unlock the sheet and change things if they want to (at least if they try unlocking and don't think "mm, it's is protected and I don't know the password"). It does protect the sheet against accidental...

I think Chandoo used the triangle symbols from the Arial font. You can find then using Insert/Symbol. They are in the collection 'Geometric shapes' which you will find if you scroll down in the symbol dialog. I don't think you can use two different fonts in the formula. If you want to use the...

If you only want to find the total, instead of also deleting it in the original data you could use you could use SUM(A1:Z1)/2 (assuming Z is the last column that has data). If all values are positive, you could also use MAX(A1:Z1)

I just came across this example: http://andypope.info/charts/hiliteaxislabels.htm