sample

I have a table with three sets of timestamps when some activity took place. I want to calculate the average of the time portion of the timestamps. I was able to get an array formula using the MOD function to work: <tbody> C/R D E F 6 Sample A Sample B Sample C 7 03/01/19 09:07:44 03/01/19...

If TextBox7.Value = 0 Then TextBox7.Value = "" Hello, I have plenty of textboxes on my userform. If the textbox value is zero I want to make it zero as in sample above. Is it possible to make it with a code for all the textboxes? Thanks.

Hi There, I'm looking for a VBA script (or formula) to find an enter stroke and add text. E.g Sample Text 123 abc Def GHI To appear: Sample Text\par 123\par abc\par \par Def\par GHI\par Apologies if this question has previously been asked and answered, I cant find anything on the forums...

I hope this is the write place for this. If not my apologies. How do you post a table in the forums (excel, Access...) I see where some people show a table with sample data to help explain their questions. Where/how do I learn how to do that?

This code only saves with the workbook name and not the text "Sample". What am I doing wrong? All answers appreciated Thanks, Ed Sub SamplePDF() Dim strFolder As String Dim i As Long 'Find the position of the period in the file name i = InStr(ActiveWorkbook.Name, ".") Filename...

Hello, I have a list where I need to get totals on cur. basis on top of the data as per the filtered account ( A1 ) basis. I need to type a formula in between E1 and E4 in curr. basis but , I do not know how I can run subtotal with if condition. Right side of the spreadsheet ( between column...

Hello Good Day, I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below. Thank you. <colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt"...

Hello Everybody i am quite a novice I need help to automatically record inventory as per invoice (outgoing) & as per purchase order (incoming) I have sample sheet which I can send you but I can’t see how to attach it here Here is a link to the sample file...

Hello I have an issue with a macro running till the end instead of waiting for a called userform input. Below is the the code and the called userform code. As you see the SamOpt2x macro finds a cell containing "Sample #1 " and selects the cell. At that point the userform macro is called and...

ok noob here but how do you make a sample picture of your excel sheet?

Dear All, I have the following sample Monthly OT Hour(Aggregated) which I need to covert as follows:- Could somebody help me out with the formula pls? Sample data set along with the desired results as follows:- 30:50:00=31:00 30:29:00=30:00 Regards

<tbody> a b c d e f g h i j 1 25 1/12/2018 2 52 From to 3 36 10/12/2018 1/12/2018 31/12/2018 4 14 61 5 25 6 74 25/9/2018 7 114 31/10/2018 8 1444 9 23 </tbody> i want total of C raw in H4 from selected date...

<tbody> original date collection date 1 10/1/2016 10/8/2016 2 01/05/2017 01/07/2017 3 10/10/2018 10/17/2018 4 10/20/2018 10/30/2018 </tbody> I have a list of 300 sample, i need to know the ones that were collected 7 days and more from the original sample for example the...

Curious to know if there is a way to take data from one table and reorder the data into into another table. My project is creating tables of soil sample data collected for environmental cleanup. First table is output from another VBA routine. NOTE: the "GP-1" is the location of a soil...

Hello Ladies and Gentlemen, I have an excel file that contains information about my clients as you see bellow [/IMG]<strike> </strike> This is actually a sample, my real file has 1018 rows and 6 columns. What I want to do is to categorize my list by Type(column4), and they way I wish to be able...

Hello, I am trying to work my way through a script that will take information from one column, concatenate it with another, repeat that for a section of cells, and then repeat all those steps with a different original field, incrementing until a blank field is reached. The data I have looks...

Hi All, I new to vba, I need the code for random sample pick based on criteria <tbody> Name Process Group Nickels MT Red Tiffany MS Green COLEMAN MQ Yellow Tomas MT Red Hill AQ Green John MT Yellow </tbody> columns A has Name columns B has Process Columns C has Group like that i...

Hi friends is possible know by sample: user go to A! and capture 100 go to G1 and capture 45 go to B1 and capture -50... is possible know the order of the capture? Thanks

Good day! I badly need help with my workbook. I put sample values on my first sheet (Obj.Data), and I want to show it on my transmittal sheet (Data.Output). I used these functions: Pivot Table the Date, so I can remove duplicates or same dates. Then, I used Data Validation, and make the Pivot...

Hi all, I'm trying to find the formulas needed in Excel to calculate Power and Sample size, as we currently use Minitab and it is tedious with a long list of inputs. I used this site http://www.real-statistics.com/sampling-distribuion/statistical-power-sample/ but I do not have a standard...