Search results for query: *

Thanks for advice on Stars, Andy.

Got there !!! Many Thanks for your patience and help. Cheers JohnB

Thanks Skip, That would fix the corrupt data in one set of data, but I wanted to find the cause of error and avoid it happening in all further operations. I think it was due to an error in my first Text to Columns action, and hopefully I've solved that problem. As you can see, I'm not very...

Thanks Skip. That corrupt data has sent me into a spin! I'll try and solve that problem before I try your formula, as there are several folders to be analyzed and I need to be sure there's no more corruption before going further. .

I'm very sorry for my errors and inexperience, skip. I hope the second much larger sample attachment will give you a better idea of my problem. I do appreciate your help JohnB

OK, I need to include a third column. Each day has a series of 15 minute files (to cover 4 hours) which have been given a value RMS for every 60 seconds with count of the seconds appearing in the new middle column. I need to be able to select the days with the lowest average RMS value. Hope...

Sorry, I see now that wont work. I'll prepare another sample with an extra column - in a minute!

Thanks Skip, I'm not sure of your suggestion, but here's a sample of the data. JohnBhttp://files.engineering.com/getfile.aspx?folder=b7f35899-6b03-426b-a4cf-a10cf133f7fc&file=Sample_1.xls

My spreadsheet has two columns with approx. 4,500 rows. First column shows a filename beginning with a string to indicate firstly the date (in dd/mm/yyyy format) and then other details e.g. 26102016_abc.wav, 26102016_xyz.wav There are about 250 rows for each date i.e. the sheet covers approx...