function

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. Z

    Get Cells "Last Modified Date" Using Formula or Function

    Hello, I'm trying to figure out a way to get a cells "last modified date" in order to use it with XLOOKUP. I've seen examples where people are using formulas to CREATE a TIMESTAMP in a separate column, but I can't use those examples as written considering I have actual dates in the column that...
  13. J

    XLOOKUP not searching despite lookup value being present in worksheet

    So I have two worksheets in sheet 1 I am trying to perform a vlookup function that goes as follows XLOOKUP(B55,'Sheet2'!P:P,'Sheet2'!D:D) where the lookup value is 16/02/2023 00:00. I know this value is present in column P of sheet2 and that it has a corresponding value in column d but whenever...
  14. D

    Custom Column returns a Function?

    I am confused why my Custom Column returns a Function instead of lists? Output: = Table.AddColumn(#"Grouped Rows", "Test", each if List.FindText(Text.Split([All Matches], ","), [Email Domain]) <> false then each let EmailDomainVar = [Email Domain] in List.Select(Text.Split([All Matches]...
  15. E

    Excel to Word, "FileLocked" with 2 open Word documents - error

    Hi all, I've been looking for a solution to my problem for way too long so I hope someone here can help. From an Excel workbook, I run a macro that will open/activate an existing Word doc, copy some info from the spreadsheet onto this word doc, then, if the user requires it, another existing...
  16. H

    function help!

    Supposing that column C2 contains the function: =LIEN_HYPERTEXTE(B2;A2) how can I delete both column B2 and A2 without affecting the column C2?
  17. C

    Rank sequentially with same rank for ties, breaks when sorting

    I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using: =SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129)) In fact, this works perfectly when sorting smallest to largest: In a ranking of 125...
  18. D

    Pulling specific columns by transpose two headers

    I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare. How can we solve it in the shortest possible way...
  19. D

    Pulling specific columns by transpose two headers

    I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare.
  20. R

    Count duplicate dates within a formula (no ranges)

    Hi I have a reference cell B2 which contains the year. I would like to create a formula that contains dates (not referenced in cells) and counts the duplicate dates. Within the formula I have the fixed dates DATE(YEAR(B2),1,1),DATE(YEAR(B2),3,2),DATE(YEAR(B2),5,1),DATE(YEAR(B2),5,9) and I would...

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