output

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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