ms excel

  1. M

    A table with symbol and their frequency to create Huffman tree and extract binary values to excel worksheet

    I have a table in excel with different values in it. I have extracted each value and its count from that table using countif function. Now I need to create a macro code that can generate binary codes for each element using Huffman's algorithm in VBA. Please guide me through, Is it possible to...
  2. S

    VB to edit VB in Multiple Excel Files

    Hello. I am trying to do the following. I am in folder ABC. I have 50 files, a.xls b.xls c.xls, etc... I want to write a script to open up file A, go into the VB, unfortunately the VB has a passcode, enter the passcode, go into module 1 and replace the one line of code with another "static" line...
  3. S

    VB Code - loop a copy and paste a specified number of times

    Hello. I have a simple worksheet for an example... I want to populate R2:R6 with audi, then copy R7:R11 with benz, etc... The real dataset I have in Column S is 100's of rows, but if I can get code using the above, I'll modify it as needed. So copy Audi to column R..starting in R2 for a...
  4. S

    Excel VB Code to open another excel file (variable)

    Hello. I have the following code that works. Sub sbVBA_To Open_Workbook() Dim wb As Workbook Set wb = Workbooks.Open("C:\Users\testuser\Desktop\export\order1.xls") My question is... can the current vb code be changed to accommodate any file name? Meaning I will export one file to the...
  5. S

    Excel VBA - How To Sort and Total Data in a Summary Tab

    Hello. I am trying to do the following. Lets say I have a order tab. Main Part # is listed in column A. Qty is next. The Main Part # consists of 4 parts which is columns D - G. I have the mid and left functions working to populate D-G... and the below screen shot. What I want to create...is a...
  6. S

    How to parse data from a cell

    Hello. What formula would I use to parse the following. JC-RO-06-L367-E201-J166-MK5C40-M14XT The number could and can be different, but the section I'm looking for the characters following the MK. So in this example I would want the formula to return 5C40. Another example...
  7. D

    Question about formulation of some desired output with CountIFS?

    Hi Everyone, I need to formulate following two desired output whose explanations can be also found in EXCEL I have copied here. I though I can use only countifs to formulate them but I could not get it worked. I will be glad with your help. Thanks you in advance...
  8. D

    I need to write following Excel formulas in MS Project. Could you please help?

    Hello Everyone, I need help from you to write formulas in MS project. I had a file in Excel. But I need to use MS Project because of management decision. MS Project formula language is different and I do not have any experience about it before. I will be really glad if you can help me about it...
  9. R

    Replacement to SUMIFS

    Hello. I am trying to use if statements and/or sumproduct instead of sumifs. When using sumifs, my macros bog down..... I am trying the following: =IF(AND((AT2:AT1000=AT2,AW2:AW1000=AW2)),SUMPRODUCT(AV2:AV1000)) Basically, if the range of at2:at1000 = the value in AT2 and if the range of...
  10. P

    Copy Command in Access 2013 VB Issues

    Hello. The following command in an older version of Access used to work: RetVal = Shell("cmd /c copy /y C:\users\abc\desktop\output.xls C:\users\abc\desktop\split files" & txtDist & ".xls", vbHide) Copy an output file from access which is working and then moves it to the split file folder and...
  11. D

    sumproduct formula returning wrong value or 0

    Hi, I have below formula that returns column number in a table however in some cases based on the slicer selection it returns 0 or wrong value. Did anyone come across similar issue and have a solution for it? =SUMPRODUCT(('Source...
  12. D

    An Issue with Data Model is preventing Microsoft Excel from opening this book error message

    Hi, I have Windows 7 and MS Office 365 Pro Plus. Anytime i click save or any button in excel i get "An Issue with Data Model is preventing Microsoft Excel from opening this book. Try restarting Microsoft Excel." error message. Did anyone had similar issue in the past and solution for it. Thanks
  13. A

    Trying to fetch data from HLOOKUP

    Hi Experts, I found myself in a situation, I Have two Sheets Data in Horizontally and want fetch some details from them vertically as following: Sheet 1 <tbody> Vauxhall Ford Hall Gearbox 500 450 600 Engine 1000 1200 800 Steering 250 350 275 Ignition 50 70 45 CYHead 300 290 310...
  14. P

    Compare 4 columns to find duplicate rows and copy one column data from all duplicate rows

    <tbody> ID First Name Last Name State Reference 1 Mark Brown CA 2257849635 2 Shawn Jack CA 2245787962 3 Smith Black CA 7789654123 4 Mark Brown CA 2257849635 5 Smith Black CA 7789654123 6 Mark Brown CA 2257849635 </tbody> I have huge data (10,00,000 rows) in the above format. Need...
  15. A

    How to get only numbers from junk text in Excel

    I want to get numbers only from a junk text field in Excel, where number length is >9 digits, if in same text have more than one number combination in a same cell so this will split in different cells Example : Cell (A2) : ABC999989898998_XYZ0998(TUV)44848333423_RKT2323_6669866666 Result ...
  16. K

    Insert data into specific cells of a word table from excel

    I need to insert data into specific cells in a word table that already exists from an excel spreadsheet. The columns will always stay the same just the rows referenced can change. I will always insert values from column A such as A3 into my first word table in the first row,second cell. Does...
  17. S

    Lock certain cells in excel

    How to lock certain cells to prevent editing in Excel?
  18. Q

    Chart : Data Label Problem

    Hi everyone I've created a bar chart using a data from the cells. When the cell show 18.96 on the data label it's also show 18.96 which is fine with me because that is what what it to show on the chart. But when the value is 55, 60 or even 100 it will show 55. , 60. and 100. on the data...
  19. K

    MS excel Query with 3+ tables and 2+ outer Joins

    Hi Everyone, I'm trying to use MS query via ODBC connection to pull data from one main table while joining two tables (left joins each) to enrich the data. I know that MS query wizard only supports one outer join, but from what I've read, the correct SQL code will work. Think of it like this...
  20. haka007

    Need Help in Formula or Macro Code on MS Excel

    Hello Members, I got a problem like this http://imageshack.us/photo/my-images/69/twoproblem.png/ Now my query is in those two files there is a column named "Expiry Date". Now, how can I change that Month & Year also to I,II,III... with their respective names, like whichever is the nearest...

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