standard

  1. B

    How to convert Now() to Eastern Standard Time

    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
  2. O

    Autofill with gaps

    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
  3. I

    Removing Outliers with standard deviation

    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...
  4. N

    Standard Deviation Function

    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...
  5. G

    need macro file with macro button to import and split the data in to multiple work books

    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. -...
  6. NewOrderFac33

    Determining RGB values of each item in the Standard Color Palette

    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...
  7. G

    Filtering with multiple criteria

    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...
  8. T

    get standard deviation from every 1st, 6th and 10th cell in column

    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
  9. G

    Standard deviation of correlation matrix

    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...
  10. S

    Create Sheet to index scores for a club

    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...
  11. E

    Excel formula to 'append' information together?

    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...
  12. R

    Standard deviation on specific days

    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...
  13. J

    Weird Date Format 20160726

    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...
  14. G

    Looking for plus/minus in VLookup data

    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...
  15. D

    Identify duplicate titles

    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...
  16. A

    Custom Date format to a standard date format

    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...
  17. B

    Break down travel time periods based on criteria

    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...
  18. JenniferMurphy

    On Error handling

    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...
  19. W

    Excel and one drive

    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?
  20. O

    Index/Match Across Workbooks with Multiple Criteria

    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...

Some videos you may like

This Week's Hot Topics

Top