function

Is there a way to combine these 4 IF functions into 1 function? =IF(AND(E3>C3,G3>E3,F3>D3,H3>F3),"UP","NO") =IF(AND(C3>E3,E3>G3,D3>F3,F3>H3),"DOWN","NO") =IF(AND(E3>C3,G3>E3,D3>F3,F3>H3),"LEFT","NO") =IF(AND(C3>E3,E3>G3,F3>D3,H3>F3),"RIGHT","NO") The most I could do is write it like...

Hi Team, I have an Excel template which itemises a list of items. The numbering of each item is what makes this task particularly challenging. Depending on the column that the item is sitting in determines the numbering increment. A picture is worth 1000 words so I'll show the general gist of...

I work on a sheet where i neecd to check if the value is duplicated in the same column "E" and if date for both duplicated value in clolumn "H" is =>TODAY() then return value as "Valid Stream" otherweise keep it clear i have reatched this formula but unfortunately it has one issue I don't...

Hello, I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line for the number of total activities per week. I have tried to make a pivot table; Unit and Category under Filters, Discipline under...

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

Hello community!!! We are trying to solve the below problem. Our system can export data like below Hotel Tourism Destination Code Hotel Name Hotel Code - TK Contracting Group Room Code Room Description Date Dest Hotel name AMTSGR0MGK OWN2 BUSD00GV00 Standard Bungalow (GardenView)...

Wondering if anyone could help me out on this one. I've created the Function below (which I'm using as an Excel Add-in), which looks up a value of the selected cell (SKU) and returns the value it finds in a specific workbook that is stored on a specific location. Right now this code it is...

So, I have 156 account numbers with 17 digits. The only numbers that matter on the account number are the last four digits. I need to take the balance of each number and sum them together based on the last four digits or a range of the last four digits. For instance, say I have 12 0000 0000 000...

Hi all! I have a report that is generated weekly for example 2401, 2402, 2403 etc. Is there a way that i can access data of these workbook from a master sheet. I have a formula that basically concatenates to the sheet name eg P:\weekly exports\2404.xlsm Is there a formula or vba that lets me...

Just thinking: If you could add any function to Excel, what would it take for arguments and what would it result/calculate?

I need code to stop running when a Table called Table2 is already there. Some reason I can`t get the Function to work with main code? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Rng Dim Result As Integer Call DeleteTbl If Selection.Count > 1 Then...

Hello, I'm trying to create a function called TextByColor using VBA. The purpose of this function is to read through one of my sheets called "JOB CODES" and the return all the cells with a white or yellow cell background to a sheet called "TV". The function should read through all of "JOB...

I need a formula that is using the data from the table named "Costs". I need to sum the Hours column IF the Concatenate column has any of these values...162FOL, 392FAL, 392FGL, 392FFL, 392PFL, or 452FGL AND the date is before 6/1/2023. This is what I currently have and it is returning a result...

Hi Everyone I have done a bit of VBA coding but usually it involves modifying existing code I have found on forums such as these - so I am at a fairly basic level. In particular I have little to no experience in writing excel functions. I am working with two different types of Google Map URL's...

hello there, i would like to know if excel could apply search based on multiple condition and return a specific value that match with all conditions and there is the assumption. if i work in a bank and the bank sometimes do investigations to some customers to check their valid to have a credit...

I have two columns - Name and value. When I want to SUM the range using SUM function, I get total sum. value. But what I'd like to do is my total sum will be auto updated if I fill any cell with a color. In the example snippet (attached), when I fill cell D12 with any color for example yellow...

Hi guys, Already tried search, but could not find an answer to my question. Is there a way to have the function NETWORKDAYS to use two list, one of holidays and another one of vacation days? I could not find an answer to this question, so, I think I will have to use only one list of "holidays...

Hi, I would like to create below function using the header name in a dynamic table in another workbook as the range. =COUNTIF([Inventory0221.xlsx]CitiPlaza!Table1[[#Headers],[ Service Tag/Serial No.]],[@[Serial number]]) the range of which I want to use the header name is...

Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...

Situation: Here is what i have working now. The VBA code will save a copy of the current sheet as an archive file in .CSV format. I'm able to assigned it to a button and it will do it on a sheet by sheet basses. This means what ever sheet the button is assigned to it will export that sheet and...