Search results for query: *

Yes - there are blanks in the column and I just want to select the first block of data. The position of the first row of the data varies, but has the first row always contains the text "surname", so I am able to locate it.

Hello Is there a way of finding the row on which a block of data ends? The first line of the data doesn't always start on the same row, and the data is varies in length. (the first row of data includes "surname" and I found that using GlennUK's tip). THANK YOU!

Thanks Glen, I don't kow what row "surname" occurs on, so the match function works well. I did have a look at Excel's help on the cell function, and used the row result. It just didn't give consistent results...

Hi I have been trying in Excel to use the cell formula to return the row number of a cell: Cell B32 contains the test "surname", so I thought that entering the formula: cell("row",'surname) which should return 32. It does sometimes, but sometimes, excel adds 1 to the number. Highlighting the...

Thank you Leigh! I used the expression: "01/" & Month(Date())+1 & "/" & DatePart("yyyy",Date()) and it seems to be working OK. I wasn't convinced that Access would recognise it as a date rather than a string, but I am using it is the defualt value for a date...

Hi I am trying to work out an expression in Access that calculates the date of the first day of the next month (e.g. for today, it would return 01/10/03). I'm tying myself in knots with datediff and datepart functions at the moment, but not getting very far. Any help would be really...

Thank you - I've tried 2 out of the 3 ways that have been suggested and they work really well. This is a great website. Thank you for tkaing the time to give me your help!

Hi I'm having real trouble using the countif formula in excel. What I want is to count the number of values above a value in another cell =COUNTIF(b8:b48,">B2") I think excel is treating B2 as text (it's formatted as a number) instead of a number and is returning 0. If I put in...

Hi Does anyone know if there is an easy way to work out the full width at half maximum in Excel? I know that you can work out the standard deviation, but I have a non-Gaussian distribution. Thank you Caitlin