Search results

Hi everyone, Thank you for the help on this question. The only tweak I need is for the Inv no.s to be in a separate column so I can do analysis on the numbers. But what you have done so far is amazing. Best, Frank

Shteven, I think it 502 - 504 means its inv 502, 503, 504. So not sure how to handle that and I may have to deal with it manually.

Hello, I need to extract Invoice numbers from a raw dataset below. I need to find all numbers after the "Inv" text string and put the three numbers associated with the invoice in the next column. But data has some strange formatting issues. How do I do this in excel using a formula or macro...

This works. Thank you so much for your help

Hi, I want help to create the following formula but I am sure how to do it. A-B = X If X is equal or less than fixed value in column C then change that value to the one found in column C. X could contain some negative values which I also need to set to the value in column C. Any ideas...

So the instrument data creates a spreadsheet with all the times for every line of data in the "Timematrix" sheet. Some sample id will be 50 seconds while others could be 200 seconds in length. I am using this sheet to calculate the max, middle range values and I pull those numbers into the raw...

In Table 1 Raw Data. SampleA_Line 1 is a measurement of signal intensity versus time. Each column represents 0.5 seconds intervals and the time numbers for that particular line are in the time matrix sheet. We need the "TimeMatrix" sheet as it contains the time data for the experiment and the...

Hi, I am including a typical example of the raw data which I loaded into a powerpivot table (it is 92mb in size!). I was hoping maybe powerpivot could be used to apply your calculation formulas in a more efficient way. I then wanted to create summary pivot tables based on specific questions...

Hi, Here is an update link to the latest version of the spreadsheet. https://www.dropbox.com/s/yds9zqvanqkr3ys/20150514_DataTemplate.xlsx?dl=0 The raw data is located at C2 and the calculation that I am trying to carry out calculations at SA2. I included a new spreadsheet called timematrix...

Hi, Here is an example of a large spreadsheet with the length of time for every line of data in the TimeMatrix spreadsheet. I will have 1000's of rows with variable Times (from 60seconds to 360 seconds in this particular example). I need to be paste the formula and quickly drag them to bottom...

Hi, You are amazing. Thank you so much for your help!!! You are correct and the range you selected were the areas that I need to calculate. If I have 1000 line of similar data but of variable times. How do I automatically apply these formulas to the entire worksheet? I need to apply similar...

Hello, I have a large amount of raw data coming off a instrument. The workbook consists multiple worksheets of data with Date, Sample ID, Time Header (seconds) and Signal (Columns A:DE). I then need to apply the same basic calculations (mean, standard deviation, median, min, max, etc) on the...

Hello, I have a number that I need to convert to the following text string formats. I have successfully converted 45 to the following text string using the custom format: Wait(45000); But it does not work with the ones below: Convert 0.05 to the following text string...