function

What is the correct syntax to use with the new 365 FILTER function to filter on a character within a string? In the example below, I would like to search for all ADIDs (column E) that has an "R" as the second character...

Hello All you wonderful Guru's, I am stuck on something and I need some guidance. I have a set of projects that have a number of different start and end dates. So its pretty easy to get total of number of days using the Networkdays function. The problem I am having that I need to break out the...

I'm at a point where i'm bringing in two columns with values (city and county) and i've got a lookup sheet where the value of the state - Say Michigan (or MI) is 45 for example and the county is 13. I'm inputting MI in to the cell but would like for it to somehow reflect 45. I'm wondering if i...

I have a set of data where we get work done by every employee on a weekly basis (eg. E01, E02) in man-days I use that data to derive the velocity data set- (Work Done/5) and use it to derive the average velocity trend for coming weeks (using AVERAGE function) Employee list is selected via drop...

Hi, I have a list of data with employees and their holiday data ranges, which I want to transform into an array with weeks (showing week ending date - Friday) to show days of absence in that week Employee Start End Week Ending --> 03-May 10-May 17-May E01 30-Apr 15-May 4 5 3 E02 08-May...

Hi, I am looking for an Excel non-VBA function formula based on two parameters. If a cell holds the value 10, then a date starting from 24 December is added, but only if this date is a workday. If this date is not a workday, then it takes the first day before this date that is a workday. If...

Hi I have an excel sheet that names a number of cells as variables. For example cell A1 is defined as speed and in formulas elsewhere in the workbook I have used speed in formulas rather than A1. I now want to write a function in VBA that uses speed in a formula. Rather than referring to A1, I...

Hello, I've got a filter formula that I'm using I noticed if any of the cells are blank (like L1, M1, N1, or O1) then I get a #calc error. Is there a way to ignore those criteria when the reference cells are blank...

Hello Everyone, I am learning C++ programming and working on a project. I want to know which programing language separates the function and data between C and C++ programming. According to this source, In The case of C++, the data and functions stay encapsulated in an object’s form but not an...

Hi, In power query when using the Table.FromList function, I add ; Splitter.SplitByNothing() after the source list, as it doesn't seem to work if you don't . It says in microsoft docs that the splitter is optional, I tried just putting the value null, but this doesn't work either, can...

Hello, I am attempting to extract data from a string. I have employees copying tabular data out of another software. The software got updated, so now copied data only gets pasted as a string in one cell. I was hoping someone is able to assist with a VBA code or a formula to extract any numbers...

Hi kind folks. As I've been learning the CHOOSE function, I've fallen in love. It's such a humble, but powerful, little function. The arguments (according to intelli-sense) are: CHOOSE(index_num, value1, [value2], [value3], [value4],...) The index_num argument can be a cell reference, but...

Hi. I am having difficulties in finding ways to highlight cells with the same formula. For example: The cell highlighted in yellow has the =X + no. of days format. Whereas the image below has the =EDATE(x,x) formula. I need the cells with same formula to be highlighted in one color, same with...

I am trying to create a function that when I enter a part number in Cell B17-B29 it will match that part # to "sheet1" and pull the pricing and description. I have all the pricing for everything on the Sheet 1 attached to this main form. For example the equation I put in was only to test the...

Hello, In the code below, I am selecting a specific range. Within that range I am replacing all the cells that contain $O$1 with a formula which contains the RowNumber. Note that everytime I run the code, the RowNumber value changes. So I cannot simply write a number as a replacement. When I...

I am trying to create a nested IF statement to look at a cell and do 3 things: 1. look to see if cell is blank, if so leave blank, 2. date in cell- todays date is < 30 print" DUE" in cell. 3. look to see if cell has NA typed in the cell, if so leave blank My code works in terms of the...

There's a web site (Market Holidays for United States for 2022) that has a small table of the list of Market Holidays. Long story short, I was able to pull in all the tables from 1900 to 2100 using a Power Query function. In doing that I discovered that 56 years (including 2017) are missing the...

I have a table with 20 rows and only 6 rows have data in them. I'm trying to get the average of only the rows containing data in a column. Can anyone help me figure out why I'm getting an error on this formula? Example: Sam 5 Jess 2 Dean 4 Michael 4

Just looking for some guidance... I'm confused on what I should be looking for as far as what formula would accomplish what I'm looking to do. I'd like to be able to look at column H, and if it has text rather than a date, I'd like to change it to the date... You can see in Column A, these...

Hi. I need help with writting a formula. I have a table with 2 or 3 columns. In the first column i have the same number in some cells,but i don't know for sure which cells. In the second and third column i have data that is different in each cell but is connected with the same number from the...