functions

  1. E

    EXCEL FORMULA

    I have four columns in excel. Column A is Date while Column B is Day. Column B depends on the value in Column B and I got the Formula for any specific date for column B and that's not my concern anymore. Column C is designated for formula. Column B and C are to be hidden (not a problem). Column...
  2. M

    Spill functions with other functions

    I have recently been looking into using spill functions more as I can have them veiw an array on another sheet and does not need to be updated if someone inserts a row in the middle of the data. Currently all my formulas will update to make room for the new row but not adjust to include the row...
  3. T

    Counting cells in a column in an array based on criteria

    In my workbook, the tab 'Data' includes the names of students who have completed either of two tests. (Note the actual workbook goes to column CG with 72 questions.) BCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD1First nameSurnameStudent NameTestDurationLow EL/INHigh EL/INLow PI/UIHigh...
  4. A

    Can someone please explain how this rearrange column macro works?

    I have found this piece of code from somewhere else, and I modified it a bit to meet my needs, but I'm not entirely sure how it works. The reason I would like to know how it works is because I would like to modify it further, but I am newer to VBA and do not understand how the Resize, Index, and...
  5. G

    Prevent formulas from recalculating on cell value deletion

    I am working on a project for work that involves HTTP requests. After struggling through getting that to work, my next problem is trying to prevent the VBA function from recalculating when one of the argument cells is cleared. Below is my attempt at a solution thus far: Function HTTPGet(ISO...
  6. DRSteele

    Utilising the function UNICHAR

    Sometimes we wish to find characters to place into our spreadsheets but are unsure where to look and how to find them. Function UNICHAR allows us to enter a number and it will report the character. Mike Girvin from ExcelIsFun recently created a youtube video that shows ways of listing them - as...
  7. W

    What language are Excel formulas written in?

    Hi there, What language are Excel formulas/functions written in? I refer to the formula bar, rather than the VBA. I guess this language must have some sort of a name. Thanks.
  8. 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...
  9. MrDB4Excel

    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?
  10. 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?
  11. 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...
  12. 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...
  13. 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.
  14. 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...
  15. 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.
  16. 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...
  17. 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?
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top