respective

  1. K

    subroutine

    i have initiated value for some variable inside a module and called a subroutine.Inside that subroutine i have formula which uses those variables.will the subroutine recognize those varibles and their respective values even if i dont pass those values as arguemetns into subroutine?
  2. K

    Cross Workbook equation to get data into another format (dealing with duplicate numbers)

    I have an IF statement pulling date onto Sheet 1 (=IF('Sheet 2'!$E$4=H15,'Sheet2'!$C$4,False). However, I have some numbers in the E column that are identical, while the respective values in row C are different. Is there a way to tell excel to move onto the next instance of the number in column...
  3. J

    VBA - Copy Paste in last workday

    Hello everybody! I'm currently facing a relatively simple problem. I have the following table: There are values in the Range B2:F2 Then there are a calender column since A5 - like below <tbody> A B C D E F 100 150 20 70 50 01.01.2019 02.01.2019...
  4. C

    Array Formula Cell References

    I have a formula that works but want to make it more dynamic rather than being hard coded. =IF(ISERROR(INDEX(employee_names,SMALL(IF(employee_1=$I$21,ROW(employee_1)),ROW(1:1))-1,1))," ",INDEX(employee_names,SMALL(IF(employee_1=$I$21,ROW(employee_1)),ROW(1:1))-1,1)) the employee_1, employee_2...
  5. K

    Division of cells using cells(ij) format

    Hi everyone, I want to divide respective cells in one column with other column and obtaining the results in next column using cells reference. Here is VBA code i am using Range(Cells(3, lastcolumn + 6), Cells(5, lastcolumn + 6)).Formula = "=" & Cells(3, lastcolumn + 4) & "/" & Cells(3...
  6. K

    Hi

    Hi I want to divide respective cells in one column with other column and obtaining the results in next column using cells reference. Here is VBA code i am using Range(Cells(3, lastcolumn + 6), Cells(5, lastcolumn + 6)).Formula = "=" & Cells(3, lastcolumn + 4) & "/" & Cells(3, lastcolumn + 5) It...
  7. N

    Require correct positioning of Boolean Value to overcome some hassles

    Hello I had to incorporate the REM marks below to see the Searched value of comboBox which displays the respective curRow Data in All Textboxes of Respective Columns of that curRow coding in Class Module: Class2AllTextboxes Option Explicit Public WithEvents AllTextBoxEvent As...
  8. N

    How can I display selected worksheet areas with command buttons?

    Hello, Would like to have worksheet sections displayed by command buttons, but I do not know how to do it. In the worksheet the month range should be displayed by clicking on the respective button. So that the respective desired month after column G appears (column A to G should always be...
  9. U

    VBA: Concatenate data with and without symbol from respective rows

    I have data with symbols like "|" and "~" and ":" from H to say N column. With VBA (using switch statement) get, In Column B and C: Concatenate data with and without "|" from respective rows In Column D and E: Concatenate data with and without "~" from respective rows In Column F and G...
  10. D

    Separate dates from particular month/year

    Hello everyone! I’m trying to resolve this issue more than week but unfortunately I couldn’t without help! I will try my best to explain exactly what I want and for your convenience I’ve made a table with examples. A B C D E 1 Dates Jun-18 Jul-18 Aug-18 Sep-18 2...
  11. J

    How do I pull multiple information from the same MainID (foreign key) in Excel?

    Hi, I am working for a company which acquires SME/retail Non Performing Loans (Say Borrower Code B_0001 to B_1000)- of which each Borrower Code may contain multiple Loans (ie B_0001 may have 2 LoanIDs (L_0001, L0002... and the running number goes on with the next Borrower. These are the...
  12. A

    Stock Quotes in Excel !!!

    Hello Friends, I have a code which gives the stock quotes in web browser. Is it possible to have list of 50 stocks from Indian Stock Market & have TO & From date columns. So whatever stock is selected from the list & respective dates, the data will be downloaded. Thanks In Advance AR
  13. S

    How to exclude anything that follows the last hyphen that starts with Text (A-Z)

    Hey all! I'm new here. I'm having some trouble with my formula. Im trying to get rid of everything after the last hyphen in the respective cells. here is what i have so far. =IF(LEN([@[column1]])<=10|[@[column2]]|IF(RIGHT([@[column1]]|1)="-"|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s...
  14. A

    if lookup doesn't work...?

    Hi Excel Gurus, I have a list of invoice number such as: 12RD000252 15RC000564 18MD000548 18MC004512 type: RD deposit RC credit MD withdraw MC credit I would like to lookup the respective invoices whether it is a deposit or a credit or a withdraw.. I have the respective formula...
  15. V

    Count require..Based on Start time

    On Sheet1 <colgroup><col><col><col span="2"></colgroup><tbody> Department Name 12:00 AM 1:00 AM 2:00 AM A B C </tbody> ....and so on till 11.00 pm On Sheet2, I have Start time data <colgroup><col></colgroup><tbody> Shift Start Time (24 hour format 13:30 13:30...
  16. N

    How to get the respective data from 15 Cells of each row in a praticular column of sheet by pressing next button in User form in respective textboxes

    Hi In Gen Module Option Explicit Public curRec As Integer Public a$() Public b$() '------------------ in Userform1 Private Sub UserForm_Initialize() curRec = 1 ReDim a$(1 To 15) ReDim b$(1 To 15) With Sheets("Sheet1") Userform1.textBox1.Text = .Cells(2, 3).Value...
  17. P

    Help with finding printer Ne port number

    Please can some one help me here. Some where I have seen a small piece of code that lists the printer name and the respective Ne port number on PC that runs the code but I can't find it today. Any ideas ? Thanks
  18. A

    Compare from 2 columns and retrive from third

    I have an excel file with 2 workbooks, one consists of ID and Sales and another consists of Client Name and Price I want, if I write Name for ID in 1st sheet then respective Sales block should take the Price value from 2nd workbook of respective Client Note: the values in ID and Client Name are...
  19. H

    Formula Help - Possibly logest / linest

    Hi Hope someone can help me with a formula involving multiple x's to find a y I have a series of x variables, some of which affect the value of y and some do not. I need help creating a formula that if I put in the x variables, and the y value, it will give me the multipliers for the x's. I am...
  20. J

    Merge data from two columns in respective rows ?

    How I can merge data from two column in single column, in respective rows. If cell is not empty then merge data start with a comma.

This Week's Hot Topics

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