standard

Hi, I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database. Thanks

Hello all, The form that I am working with requires me to pull the information from a different sheet. The information is stored with a gap of 38 rows, so standard autofill doesn't work. Is it possible to achieve this? thank you, Oksana

Hello, I am working on a project and told to remove all outliers by using the ? +- 3? approach. I am wondering how i should go about this? do i need to calculate the mean and all quartiles to remove the outliers or is there a single excel function that can remove the data outside 3 standard...

Hello, I am wondering if there is a way to do a standard deviation ifs function. I am trying to take the standard deviation from a specific criteria within a spread sheet so for example: one of the criteria I need to fulfill is <=8.5 & >=2.9 & >=18 <=26. So I will need 4 criteria that will need...

I need a macro file with the macro button where it should work as below. - When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format) - Once I selected the report it should ask for the column name to input. -...

Good afternoon, Nice for for somebody for a Friday afternoon! :-) I know how to use the 56 .ColorIndex values, and how to set an interior or font color to an RGB value, but does anyone know of a quick way to return the RGB value of each element in the Standard Color Palette (Excel 2016) to a...

Hi All, I have to extract some data's from large number of Dump data with multiple filtering.Which should to shown in summary sheet while updating the dump data for next frequency.Here below a sample data. Summary sheet : -------------------- July Aug Total Marks by 1...

Hello I have a column of data. The # of rows are always multiples of 10. How to get the standard deviation from the cells in each 1st, 6th and 10th row? For example if I had 100 rows. I would want the standard deviation from rows 1,6,10,11,16,20,21,26,30...91,96,100 Thanks Tom

I am looking to get the standard deviation of each correlation coefficient in a matrix. The matrix is complete (as in each pairwise correlation in included twice) but i want the standard deviation including only each coefficient once. The matrix will vary in size and can be quite large so i...

Good day All, I need to extract data from an excel sheet and index them on another sheet to formulate results with handicaps etc. I am struggling on extracting the data: <tbody> Division Stage Number Name Hit Factor Classic 1 Ira 2.57 Classic 2 Ira 0.97 Standard 1 Jason 5.36 Standard...

Hi all - I am attempting to use Excel to find information from one table and assign it to other tables....which is normally easy....but there is a conundrum I have run across. For example: <tbody> I currently have this information: Standard Section Activity 200.01-14 627 200.15-17...

I have some data that I need averages and standard deviations on specific days. Averages are easy with Averageif but I can't find anything similar for STDEV. I've tried putting a IF statement inside STDEV but keep getting NAME or VALUE errors. My data looks like this: Data...

I have a spreadsheet that is sent to me with a strange date format that I would like to convert to a more standard format. It looks like this when I get it: 20160726 Which translates to 07/26/2016. There are about 58,000 rows with this weird date. What do you think would be the fastest way...

Hi, I use a spreadsheet that uses a formula to find whether the part needed for a job is standard or do we need a custom made piece. This is the formula IF(ISERROR(VLOOKUP(C31,G40:H83,2,0)),(B31*C31)*H38,VLOOKUP(C31,G40:H83,2,0)) and the data base it searches has all our standard sizes in it. I...

Hi All, Could someone please assist with the below query as I couldn't figure out the way to do it. I have two columns(A&B) with document numbers (same numbers exist in column A due to multiple versions- draft, version 1, final etc) and Titles. Some document numbers have same titles, which...

Hi All, Apologies if this is totally daft, nube etc. I'm fairly green to excel, so your assistance and forgiveness is sought after. I have been given a date in the following format as plain text "MAR 4, 2019" and I wish to convert it to 04/03/2019 using excel. I have 1400 different the...

I'm making a travel time sheet for technicians to fill in travel, the input should be broken down based on driving time period. Between 7AM and 5 PM should be considered as standard time, before 7AM is morning, after 5 PM is Evening This is easy, the hard part for me is to break it up when there...

This web page, http://www.cpearson.com/excel/ErrorHandling.htm has this to say about On Error GoTo 0 In my code, it isn't working. This line causes a Value error in the calling cell. Parms = Split(PArgs(i), "=") VBA does not "display its standard run time message box" as claimed above. I...

I have several workbooks on our network that have linked cells to each other. I wanted to move them to One Drive so I can access from anywhere but the links break. Is there a way to avoid this? Need I link it differently than the standard copy past link?

Hello, I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having...