function

  1. T

    Formula Causes Memory Leak...Sometimes?!? Help me diagnose

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

    How to find duplicate values in one column while checking if a condition in another column is met

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

    Grand total line as a secondary axis to a clustered column

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

    VLOOKUP issue with wildcard parameter for partial matches in number/letter combinations

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

    Turn Continues Vertical Values Into One Row With Min & Max Values

    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)...
  6. D

    Vlookup to a closed Workbook via Function / Excel Add-In

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

    Have a 156 account numbers, I need to calculate the totals based on the last 4 digits... but wait there's more

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

    Access data from a closed workbook

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

    What function would you like to see in Excel?

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

    Please could you help with Named Table

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

    Trying to create a TextByColor function

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

    SUMIFS Statement

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

    Google MAP URL Function

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

    Search based on multiple conditions.

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

    SUM column ranges skipping cells with background color

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

    NETWORKDAYS function with holidays and vacation days list

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

    Using column header as dynamic range

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

    VBA - Code That Will Log Cell Change Record By A Range And Log It

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

    VBA Macro to Export Data from Excel Spreadsheet to CSV

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

    VBA Code To Timestamp & Username For Anything That Changes In a Select Range

    I have both sides of the code but do not know how to join them together. One part of the cod will pull the Windows user name but not work with a selected range and not work with if there is a change in that range. The other part works with with timestamping when ever there is a change within a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top