standard

Hi Guys, I'll do my utmost to explain clearly and hopefully one of you excel mages can help me! I have a userform in which audit data is input. At the top of the userform are combo and text boxes for selecting "Department", "Area" and inputting the date. Below that are some rows of labels...

Hello! First, I want to say how much I appreciate this community... it's been a huge help with my Excel questions! Input data example <tbody> Customer Name Date Product QTY John Doe 1/24/2016 Paint, Standard Green 2 1/24/2016 Shelf, H1 6 1/24/2016 Backer, H1 6 5/14/2016 Shelf...

How do I use =NOW() to give me the current date (of course), but standard time, not military time. For ex, I want the time after the date to show as 4:00 not 1600.

Hi I apologise if this is a remarkably silly question. All I want to do is to use the auto-generated data entry form as a basic form that I can modify by going into the normal vba window. In other words, I want to save the data-entry form that can be created automatically from a...

Given the following data: <colgroup><col span="6"><col></colgroup><tbody> Material Class Y_ID Y_OD Y_L MatlCode STD 109.02253 PR09 152.4 172.9 8.1 T23 S 109.02635 PR09 228.6 244.3 6.3 T23 109.02754 PR09 238.13 259.31 8.1 T23 109.03071 PR09 95.1738 109.982 6.2992 T23 109.03287...

I am creating a spreadsheet for our Sales Reps to use to calculate their commissions. In this spreadsheet, there are several drop-down lists that they can select from. For Example: Order Type: Commercial, Government, State Sales Type: Standard, Promotional, Government Maintenance: None...

Hi, I am using the standard Data Validation dropdown box in a cell. Is there any place you can change the font in the dropdown/cell, it sometimes comes out small and it doesn't seem like you can control that? Thank you in Advance Nuc

Im looking to find the closest match to a cell in a list. So I have two column, =LEFT(A5,4)&"x"&LEFT(B5,2) as the example Frontage Depth Product ' 10.7 26 10.7X26 standard products rate per metre...

Hi everyone! Is this possible in Excel?? Let's say I have 10 rows of numerical data across 10 columns, and I'd like to find the Standard Deviation of the numbers across each row. In the end I would have 10 standard deviations (one for each row) that I could then average. Simple enough if...

I need to suppress data points that are zero on a chart linked to a table. I have achieved this with a standard chart using NA() in the IF statement that generates the data to be charted. The NA() generates a #N/A in the data which a standard chart ignores, this does not seem to work with a...

Hi all, I'm a bit confused about what value I'm supposed to use in the lognormal.dist and other lognormal formulas for the mean and standard deviation parameters. For example if my x range is in B:B and the log of x is in range C:C is the mean: 1: Average(B:B) 2. Average(ln(B:B)) 3. Average...

I wish to calculate the standard deviation of Brand A Product 1-5 and Brand B Product 1-5. Is there any shortcut for this? I call this a brand pairing and I have 300 brand pairing to be done. Help is needed! :( <tbody> Brand Product Demand A 1 3 A 2 4 A 3 12 A 4 35 A 5 6 A 6 8 A 7...

Hello, Im working on calculating the z score based on work type, finding the standard deviation based on the work type has proven difficult. On column E I have the work type example Basic, Advanced, Medium, on column F I have the scores. How would I calculate the standard deviation based on...

I have 2 columns of data. I need to count how many Advanced are also Safety and so on and so forth. How many Major are Safety, CD, etc. How many Advanced are Safety, CD, etc. ??? <tbody> Advanced Safety Major CD Standard PD Advanced Safety Advanced PD Major QC Advanced PD...

In column E I can select 4 words from a list: Quick, Standard, Major, and Advanced. If I select Quick in column E, I want the adjacent cell in column F to automatically populate 2018QK1. If I select Standard in the next cell in column E, I want the adjacent cell to populate 2018SK1. Selecting...

Hi! I have daily data for stock market returns in column B. And the corresponding date (dd/mm/yyyy) of each observation in column A. I want to compute the STDEV of last 12 months daily returns. And get a standard deviation value for the first day of each month, which I will assume as the...

I need to find the standard deviation of data from the previous month. So, in column "A" I have dates, and column "B" I have my data. Data is being added multiple times a day. So then I have my cell that shows the standard deviation in Cell C1. How would I write the formula to only show the...

Hi im in the process of creating custom buttons for my userforms , but Im not sure what is considered standard size for buttons ? anyone have a good suggestion ? frederik

Hi is there a way to do such a trick: Dim cell As Range For Each cell In Range("Table1[col3]") cell.Value = Range("Table1[@col1]") Next cell or is using standard for look a better idea?

Hi there, I have a table with two columns (a1:b200). I need to calculate the standard deviation of the values in column B, but only for those values where a condition in column A is being met. For example: column A contains only the numbers 0 and 1 and I want only to include all numbers in...