output

  1. N

    How to split multiple worksheets of data by column value and output to separate files?

    I have an Excel 2010 workbook (let's call it 'Master') with many worksheets, whatever name. Each worksheet has data structured as shown below. One of the columns has an identifier, such as a supplier code. Both sheets on the Master are sorted on Column1_header. Note: The actual structure is...
  2. R

    If function ignoring NA

    Hello guys, I have a column of numbers and some NA. I am creating dummy variables, for example, IF(A2>0.7,1,0) and repeat this function into the entire column. However, I have NA in this column. Therefore, how can I ignore NA and set the output of NA as 'NO'. Thank you so much.
  3. kelly mort

    Scramble a string with conditions

    I want to scramble a given string then store the various combinations to a variable or an array based on what you think is cool for my demand. I came across this pieces but they are not exactly what I wanted. Now this is what I wanna achieve; my code will take a string in the form “AABB” eg...
  4. R

    Require formula

    Hello, I have data as mentioned below in each row. ,,,,,,,,,,,,,,,,AM,,,,,,,,,,,FE,,,,,,,BA ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,DD,,,,,, HQ,,,,,,,BB,,,,,,,,,,,,,,,,,,,,,,,DF The output that I require is as mentioned below. AM,FE,BA DD HQ,BB,DF Regards, Vikas
  5. JackDanIce

    Publish Excel dashboard online / to Company's GDrive

    Hi, Researching creating online, interactive dashboards and am stuck with the process of setting one up as a demo. At present, I have an Excel spreadsheet with a datatable sheet, input driver variables (separate sheet) and an output sheet (i.e. dashboard) The company, currently uses Google...
  6. S

    Getting a store chain's name from a branch

    Let's say I have the store column below. I'm trying to make a formula that will scrub the column and return an output with just the type of store as shown in the "Desired Output" column. Because the amount of words before/after the type varies, I couldn't use the mid function to look for a set...
  7. R

    Consolidate rows with a macro based on lack of value in certain columns

    I'm working on fixing a spreadsheet for work with very little VBA knowledge. I've got the original sheet working again but now would like to add a consolidation button for times when the outputted table is too long. This is an example of the output table from the macro: I'd like to output to...
  8. B

    lookup logic to interrogate specific exceptions

    Hello, See the below data example. Purpose: Output a 'Y' or 'N' based on a look-up. If the data is found in the columns in the look-up, a 'Y' is output, else 'N'. This is probably a IF/THEN type logic, but your assistance is greatly appreciated! Logic/Rules: 1) If the look-up matches...
  9. F

    Vlookup on multiple matches

    Dear All I have a query related to multiple matches through VLookup In my attached sheet I have 2 list. List1 has Field1 and Time. List 2 has Field2 Field2 matches to Field1 to get the output on column E through Vlookup. But due to multiple matches I cant have the desired output. Desired...
  10. S

    Merge Every 3 Rows into 1 row

    I have a data file of say 60,000 records and each record are up to column K. I need to combine every 3 rows as one row into a new worksheet. Input rows will be: A2 to K2, A3 to K3 and A4 to K4 Output will be on a new worksheet will be from: A2 to AG2 This formula will be for entire worksheet...
  11. C

    Check a list of values against multiple columns and output a list that appears in each?

    I'm stumped. Been trying this all morning. I have an excel file with two sheets: A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet. B. Daily Orders -- contains lists of each day's purchased...
  12. D

    Input and output in Excel

    Hi all, i am have a small issue with my excel function. my goal is if i enter a file name it outputs the drive letter is should be on. the problem is that all of the file names are numbers and i only want it to search the first three characters but it does not. my function is...
  13. D

    Questions before diving in a cash management model using powerpivot and DAX

    Hi there, I'm refreshing/improving a cash management tool / dashboard I developed last year and I'm looking into information to do it the right way. The environment is as follow : - group has several companies and multiple bank account per company - some account are checking accounts and some...
  14. D

    How to transpose(?) column to desired output

    Book1ABCDEFGH1INV2268385329-May-194JOB: T00009719528-Jun-1961,394.5271,394.5281,394.529INV102684661129-May-1912JOB: T000097091328-Jun-19141,947.08151,947.08163,341.601718INV26838529-May-19JOB: T0000971928-Jun-191,394.521,394.521,394.5219INV26846629-May-19JOB...
  15. A

    format Date VBA

    I want to format the date output as "mm/dd/yy", however the code is not accomplishing what I want Original code output display show 1/15/2019 Cells(SRow, 22) = Cells(RowNum, 3) I tried this, but nothing happens. the output display show 1/15/2019 Cells(SRow, 22) = Format(Cells(RowNum...
  16. T

    How would you set this up - building from scratch

    I'm building a Macro for a project. It's going really well but quite a learning curve. The project has about 20 outputs. The first steps for all 20 are the same, but at a certain point the process diverges for each, mainly in terms of producing a Pivot Table with different fields (but all from...
  17. B

    Error 1004 when saving copied worksheets as new workbook

    I am automating the production of a load of output reports, and was getting a 400 Error when I tried to run. I have now narrowed it down and through the err.description have identified it as a 1004 error "The cell or chart you're trying to change is on a protected sheet. To make a change...
  18. L

    Weight Break calculations - A method question

    Hey everyone, Although this account is new I have been around before and ive always gotten good answers and im hoping once again i may get some help. This question is about how to convert a single line of parameters into slightly different static parameters. I could quite easily create a...
  19. F

    How to programmatically create a document with Excel data?

    Let's say I have an Excel spreadsheet with 3 columns (Name, Wife, date of death). Let's say I want to create a Word document that takes those three columns worth of date and prints it to the document like this: John Doe married Jane Jones and he died 1 Apr 2014. Sometimes, however, the person...
  20. J

    IF "THIS or THIS or THIS" then DOTHIS BUT IF "THIS or THIS or THIS" AND ALSO "THAT" then DOTHAT

    Sorry if the title is confusing, I think i might be going crazy by now haha. Trying to look at two columns of data and output accordingly. to simplify it lets say COLUMN A can have data input either (1,2,3) or any combination of them ie. 12, 123, 13, 23 COLUMN B can have data input (1, 2...

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