functions

  1. C

    Passing a workbook name and worksheet number to find out worksheet's name

    I am wanting to find out the worksheet name for a worksheet in another workbook. I have another function that does the reverse but I now can't find where I use it, in amongst 20+ spreadsheets, so this is very frustrating. I have adapted the name to number spreadsheet, but all I am always...
  2. M

    Sequence Function

    I am not sure this forum is the right place to ask about this. I use Excel 2013 and have been looking for a downloadable add-in of the sequence function. Is there such an add-in? If so where can it be found?
  3. Rblack40

    XLOOKUP in Excel 2019

    When will XLOOKUP and the other new functions be added into Excel Office 365 or Excel 2019? Will I have to know it for the test?
  4. P

    TITLE Link Formatting of Another Cell

    Hello All, I am trying to retrieve the formatting of the cell that is Matched using the INDEX and MATCH functions and then apply that formatting exactly to a cell currently using this formula: =IF(D1="","",IF(INDEX('WORK ORDER DATABASE'!W7:W157,MATCH(CO19230COLP!D1,'WORK ORDER...
  5. A

    32 to 64 bit

    Someone has asked if an App I have can work in their 64 bit Office. (I think it's the online one). I installed 64 bit office 2010 onto my laptop to find out. Running the xlsm file brings up a pile of problem but I did manage to alter all the Functions to ptrsafe Functions. Then there are lots...
  6. L

    (substitute, replace) VS replace tool

    Hi I know how and when to use substitute() and replace() function. But my question, I found that Replace tool is doing the same. Is there any case that Replace tool is not going to help then I will have to use substitute() or replace() functions. Thank you very much.
  7. A

    Lag on First Data Entry after Recalc

    Hi, I'm using Excel 2016 64bit on Win10. I have a 195Mb workbook, 7 sheets. Set to manual recalc and the book calcs in 2-3 seconds which is fine. My issue is that enter entering a value in one of the 50 or so input cells (all on sheet1), excel is typically unresponsive for up to 20 seconds...
  8. T

    I'd like to count cells with TRUE value in conditional formatting

    Using countif doesn't work because formula in CF (= i don't wanna enter conditional formatting always) is too long with many other functions and there are 4 cells. Is there any other way to get results of formulas in CF outside CF? Thank you.
  9. W

    Useful Excel formulas which people have shared

    Hello, Does MrExcel have a place to view useful formulas that people have shared over the years? If not, does anyone know of a good source for those types of formulas (hopefully categorized for easier/quicker finding)? I'm not referring to a list of Excel functions (which are readily available...
  10. C

    Return column of far most right value in a row

    Hi, In column range A-Z, row 1, there are cell values in E1, M1, Y1, the rest are blank. What functions can I use to determine the far most right column containing any value, in this case Y?
  11. R

    VBA Function Background Operation

    I wrote custom VBA functions in Excel that stop continuously calculating when I activate a different workbook. They are populated with RTD streaming from ThinkorSwim and generate audible alerts when certain conditions are met. They work great until I open/activate another workbook and then...
  12. willow1985

    IF-INDEX-MATCH: Multiple IF functions with multiple matches returning various results

    URGENT: I am having a problem with the below formula and seem to be having an off day and can't figure this out. The formula will match the first criteria but not the second and 3rd IF functions. It will just return "False" for the other 2. Any idea what I am missing...
  13. T

    Copy cell to new tab from another tab but skip empty cells

    Hi, Please HELP! I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell. TAB 1 (ColumnA) (ColumnB) <tbody> Name Amount Anne OFF Amy Mike Doe OFF Anne...
  14. C

    New column functions carry over

    Hi, I have an excel sheet with a whole heap of functions in each column, and when I insert a new column I'd like to have the functions automatically populate the new column without having to drag the rows into it individually. Is this possible? Thanks :)
  15. L

    Calculation bottleneck in a large financial model

    I built a fairly large and complicated financial model for valuation purpose, I’m now concerned with calculation speed. A couple of questions: Does table slows down calculation a lot? My data is kept in tables so that other formula referring to the data will auto update when adding deleting...
  16. C

    Protection - One time usage only in Office 365

    When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...
  17. C

    Table lookup

    Hi, I am currently using excel 2016 and I am trying to create a formula that can look up a specific table name and return the entire data table, but I am not sure how I would go about doing this. I have tried using the lookup functions but that wont return the entire table. If anyone has any...
  18. V

    Now that I understand the last parameter in VLOOKUP(), i now have thousands of problems

    Team: The last parameter in VLOOKUP() essentially tells EXCEL whether the range being used for lookup is in ASCII order or not. If not, it has to plow through all the entries in the range, as opposed to doing a binary "search all" (of COBOL fame). So not understanding this for a long time, most...
  19. B

    How calculate the sum of several functions in vba

    HI5 folks, I'd like to know how to calculate the sum of one function that has several values from 1,2,3 .... to n the function is z = (((1 + w) ^ 2))l = (((p) ^ (n - 1))) y = ((z * l)) ^ ((n) / 2) I'd like to know how to calculate the sum ∑ of y, for example from 1,2,3 .... to 10 when...
  20. S

    Formula will not transfer into VBA

    Hi All! I am trying to put this worksheet function =IFERROR(VLOOKUP(SUBSTITUTE(E2,"/","-"),Master!$E:$E,1,FALSE),VLOOKUP(E2*1,Master!$E:$E,1,FALSE)) Into some VBA code that just drops the formula into a cell and copies it down the length of the data set. For some reason it is throwing me a...

Some videos you may like

This Week's Hot Topics

Top