function

Hi, I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets). DATA sheet: All text/numbers. No formulas in this sheet. RESULT sheet: CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...

I am unsure if this can be done, I have searched around and nothing quite his the mark. What I am trying to do is write something that looks at the date and time columns and if they are within 5 seconds of each other will look at two other columns within the data and if they are the same...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

Hello, I'll try and keep this simple. Sheet 1: Current 12 Months In column B, I have a list of employee IDs. As this is an absence tracker, each separate occasion of absence for each employee is added as a new row (so the same employee could have multiple rows). Sheet 2: Occasions Current 12...

Hello, It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post. I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...

Hi All, I need to figure out how to avoid nested IF-s because I have to determine if the value of cell A1 falls between one of the 20-ish ranges of values, and and return a value based on the result So the cell A1 can contain any integer between 0 and 375 the ranges for which I have to...

I have created a table which calculates a date using two fields. The three fields are Start date (Date field) Recurrence (Choice: Month, Year, 3 years) Next recurrence (Calculated column with date result) The rule is If Recurrence is Month the Next recurrence will be Start date - 1 day and + 1...

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