equivalent

  1. C

    What is the mac equivalent of ctrl+j in the text to columns wizard?

    I'm writing a macro and one of the steps involves splitting multiple rows in one cell into their own separate rows. What is the equivalent of hitting ctrl+J in the text to columns wizard? I've already tried ⌘+J, ^+J, and ⌥+J, but those aren't working. If anyone knows of a chart that lists the...
  2. A

    VBA equivalent of Worksheet Function

    Hi everyone, I am new to VBA and this forum, so, please forgive me if I'm doing something work. I have been fairly successful with what I am trying to write in VBA, but right now I need some help. Basically, I've been trying to identify the cell number and row in a spreadsheet that matches a...
  3. E

    Is it possible to mark when formulas are not the same in a column?

    Hello Is it possible to mark and make visible that formulas in each column are not the same for all the cells of the column? by same I mean 'equivalent' Thanks!
  4. J

    access equivalent to Text function

    I have a db filed with numbers stored as strings. I need to convert them to 9 characters but some had their leading zeroes trimmed off at some point. So, 012345678 became 12345678. I would normally do Text(stringHere,"000000000") to convert this in Excel. Is there an equivalent function in...
  5. T

    use active column in range

    What would be the equivalent of Range("C" & ActiveCell.Row) for columns? Thanks Tom
  6. J

    Do While & Number Advancing

    MrExcel forums to the rescue again - furthermore, I always give full credit back to the forums when folks ask "how did you figure that out!?" Cell B1 contains a number, we'll say "25"; I would like to increment the number in cell A1, beginning at "1" until it reaches the equivalent of B1 then...
  7. Johnny C

    Excel VBA equivalent to System.IO.Path.GetInvalidFilenameChars

    System.IO.Path.GetInvalidFilenameChars is the list of valid file name chars in vb.Net Is there an equivalent setting in VBA? I can't get into the registry here at work, IT have locked it down to prevent people like me from tinkering :)
  8. T

    Find data from a column and see if it matches the concatenated equivalent to 3 columns

    I have 3 columns with the following values: A B C 1 8 2 2 5 4 3 2 6 In column F I have the following data with a separator of | between the values. 1 | 3 | 4 3 | 2 | 6 I want to find if the values column F are in the concatenated equivalent of each record in ABC above. I know I could...
  9. A

    Help debugging a Sumproduct for criteria in 2 rows and 1 column

    Hi Guys - Can someone help me come up with a formula that will be the equivalent of the below but without the need for arrays (Ctrl-shift-enter)? =SUMPRODUCT((Expenses!$R$10:$R$26=$O19)*(Expenses!$T$5:$BG$5=$B$3)*(Expenses!$T$7:$BG$7=B$6)*Expenses!$T$8:$BG$26) Thanks! Alyssa
  10. A

    Getting Decimal Equivalent of Textbox Time Entry

    I'm a bit stumped ... when I enter "0:00" into textbox 'cu2_end' .... etc_cu2 = CDate(cu2_end.Value) Debug.Print etc_cu2 I am returned the correct value for 'etc_cu2' which is 12:00:00 AM. How can I get the decimal equivalent returned for 'cu2_end'?
  11. A

    MrR or equivalent of MrExel but for R

    Is there a forum that is as awesome as MrExcel but for R?
  12. 6

    calculate monthly interest given annual interest

    Given an annual interest of 10%, how do you calculate the equivalent monthly interest?
  13. H

    javascript THIS in vba

    Hello Is there an equivalent function in VBA as THIS in javascript? Regards
  14. T

    SUMIFS equivalent: Power BI / PowerPivot

    Help !! Been struggling to find the correct DAX formula for a column - the equivalent of a SUMIFS in Excel, to obtain a unique count for "In" items by stock number (below). For Excel, =COUNTIFS($A$2:$A$11,$A2,$B$2:$B$11,"=In") does the job Stock # Indicator Count 24461875 In 2...
  15. M

    Help required for translating formula to a VBA command

    Hi I'm using in my sheet the following formula in column R =if(Q2<>"",VLOOKUP(Q2,Sheet2!A:B,2,FALSE),""). What it is doing is: if in column Q there is a "TEXT" and If the equivalent "TEXT" is found in Sheet2, column A, get value in column B. It would be great to have the equivalent vba command...
  16. O

    Excel "isoweeknum" equivalent function in Access

    Hi there, In excel i use isoweeknum for week number. In Access what is the equivalent function for it to convert a date dd/mm/yyyy into ISO week num? Thanks
  17. M

    Convert large 18 digit integer numbers to Hexadecimal number

    Hi, I am looking to convert large 18 digit (Product Serial Numbers - Electronic Serial Numbers) numbers to its equivalent Hexadecimal numbers. Since my number is huge, I am getting #NUM ! error when I use DEC2HEX function. Can anyone please suggest me how do I do that in Excel? My data looks...
  18. A

    Excel UNICODE equivalent in Power Query

    Hi all, What is the equivalent of excel UNICODE function in Power Query?
  19. M

    Is there an Excel 2010 equivalent for FORMULATEXT?

    The formula I have in cell A1 is ='New Product Business'!A11. I would like other cells in the current worksheet to be relative to this formula. I came across FORMULATEXT and it seems that by combining this with OFFSET I could achieve what I need to do. However, I have Excel 2010 and FORMULATEXT...

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