equivalent

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

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

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!

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

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

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

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 :)

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

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

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'?

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

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

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

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

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

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

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

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

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