matter

Hi I have 3 values. Average = 100 Average+ standard deviation = 100+10 Average- standard deviation = 100-10 I want to draw a chart that show each value as below. The vertical value does not matter (I mean the line height). Is that possible . Thank you

Hi-- I have a list of values in columns, organized by date. I'm trying to return the first instance of a specific value no matter the column it's in: <tbody> Date Box1 Box2 Box3 Box4 Box5 10/31/17 31 53 6 28 52 11/03/17 69 10 61 42 22 11/07/17 1 68 69 60 54 11/10/17 6 38 42 23 69...

https://trumpexcel.com/count-unique-values-in-excel-countif/ On this page explains the formula, he states that if you get DIV/0 errors it's because there is a blank value somewhere in the formula which counts it as a "0", which it cannot divide. The formula is as follows...

Hello everybody. I've a value in a cell in hour format: 00:05:37 I need to transform it in seconds: 337 How can I manage the matter? Thank's.

I'm trying to figure out a way to pull specific text from a long mesh of test in a cell (R). For example, <tbody> "SF123811#ARR676#Unbilled AR Trueup" this is an example of what could be in cell R </tbody> and this formula works when I'm trying to pull the ARR number...

Hi Not sure how to do this for color. I think yellow color is 65535 but if its not or it doesn't matter? Trying to use a macro for this.

Hello, Is there a function that allows you to skip holidays (not count) when working with date ranges? I don't want to use the WORKDAY.INTL or WEEKDAY, etc. I just want the holidays that I indicate not counted. No matter what day of the week they fall on within my range. Let me know if this...

I am trying to count the number of M's listed in four sections of a sheet but it will only return the value of 0 no matter what I put in the cells. Does anyone know why it does this because it doesn't make sense. Example: =COUNTIFS(A1:C1,"M",A2:C2,"M")

Hi, How can I change data type to text for all columns no matter what steps has been done before and what columns I have currently?? Is it possible?

=VLOOKUP([@CR],XP_table,2,XP_2) this breaks from one line in the table and the next. on line 33 of the table it returns the proper answer one line 34 it goes to #value ! now the table it is looking up ends on line 33 but that shouldn't matter as far as I can tell!

Hi, Please help with this problem. I tried searching other posts for answers as well. I have a main workbook, Main.xlsm I want to have a macro in there that can loop through and import data from whatever xls files are in a specific folder into new worksheets. The folder is...

Does anyone know if there is a way to put a formula in a bar chart that will automatically highlight a bar based on a word? For instance below, I want the company bar to automatically turn green no matter where it shows up on the graph so that I don’t have to do it automatically every month...

I have a table of data that is pulled from an external website via API. I am referencing one of the cells in the same workbook but different workpage, the data are all numbers. No matter which format I choose it will not change, for example one cell that I am referencing is 8000000000. I want it...

I am looking to create a worksheet where I can track trends within a row. There are about 20 different optional trends and each user can pick up to 5 trends per row. However, I want to be able to analyse these trends as a whole in a pivot table (rather than separated as trend 1, trend 2 etc). It...

Hello, I am looking if someone can make VBA that can highlights last 3 rows in the column C:I if finds the sequence of "1X2" order does not matter must be all 3 character there As per example below...

Hello - Looking for a FORMULA that can find all instances of parentheses and replace with an S. There can be up to 50 parentheses in a cell if that matter. A1 = H2N-(dA)(dVaaaa)(Dava)(dC/CyMal)-OH A2 - H2N-SSSS-OH Possible?

Hi all, Just a quick Excel question on sumproduct functions. Are there certain cases where you use "," verses "*" between criterias? Does it matter?

Hi, I have a lot of info on my file and everything was working perfectly for columns A to Z. But when I got to looking up data from AA onward it'll come up as 0. The formula I have is: =IFERROR(VLOOKUP($B5,Review!$A$4:$Y$100,26,FALSE)*VLOOKUP($B5,Review!$A$4:$Y$100,27,FALSE),0) Like I said when...

Hi guys, I'm having some difficulty inputting time into my worksheet. After some research I used this formatting: 0":"00":"00 AM/PM hoping to type "80000" and get "8:00:00 AM" The goal is to simplify input of time, no semicolon etc. Unfortunately this doesn't work once the time gets to PM...

Good morning. I have a spreadsheet which looks like the table below. I have data on a separate worksheet which will add the practice area when I enter in the person's initials. I'd like to populate the Location column using the initials in column B on the active worksheet and for some reason...