output

  1. R

    CSV format adjustments / filterout only needed items

    Hello guys, i am glad i found this forum and saw a lot of solution but unfortunately i was not able to find something that would help me, or atleast i could not understand that. What i am looking for is a preferably script (editable if something changes) which will help me out with CSV file...
  2. J

    VBA: Userform Input to Output

    I am creating a userform that takes a PPM file and lets the user apply filters to it. There is a input textbox that lets the user pick their PPM file to edit, and a output textbox that is suppose to hold the new edited file. I have option buttons that apply filters to the input file. I also have...
  3. A

    search and extract the patterns

    Hi There, can derive the output in multiple steps, but looking forward to find a formulae to do it one single step.. I tried using combinations of SEARCH,ISNUMBER functions, but did not get it right. So your help is highly appreciated. <colgroup><col span="2"><col></colgroup><tbody> Text...
  4. R

    Conditional Formatting with Duplicate Rows to Identify Most Recent Value

    I have multiple rows with identical values in 3 columns and the 4th column has a unique value based on the date when it is sold. Can someone please help me in creating a 5th column which will show me based on conditional formatting value which was sold earlier and which was sold more recently...
  5. A

    Need help regarding search string function

    I am using below function to search a string for a matching word from another string and the logical test is performed and if true (e.g., XXX), the value_if_true output is given (e.g., YYY), else the output in the value_if_false parameter is given...
  6. P

    SUMIFS Wildcard

    Hi Guys, I'm using Excel 2016 and trying to retrieve some values from a table, here's a simple example; <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Dept Sub Dept Sales Dept A Dept A1 100 Dept A Dept A2 150 Dept B Dept B1 500...
  7. D

    Append last row from csv file to worksheet

    Hi, I have an output file from a device which is appended to each time the device is used. I then need to add some additional data to output in a separate excel sheet via some control buttons. My plan is to import the last line from the output csv in to a results sheet then add some qualifiying...
  8. J

    Multiple Input Vlookup with Multiple Outputs

    I searched and didn't see anything like what I have. Here is what I want to do: <tbody> A 1 B C D 4 E F 6 G </tbody> Should the input be 'A,B,C,D,E,F,G' I want a separate cell to output '1,4,6' If the input is 'A,B,C,D,E' the output should be '1,4' Basically, the formula...
  9. L

    Dynamically Filtering of Table rows based on selection of cells present on another table?

    I have a table (lets call it table 1) with multiple rows and columns on sheet 1. On sheet 2, I have a second table with a series of cell values (table 2) that correspond to certain cells in table 1. I would like to use these values to filter the rows that contain these values in table 1 and...
  10. D

    Copy and Paste Fields in a different sequence

    Hi All I have an output from a report and basically what I need to do is copy and paste some only of the fields from the output in a different sequence in a new sheet. The AS-IS Output is the report below and basically I just need to copy and paste 3 columns into a new sheet TO-BE Sheet in a...
  11. C

    IFERROR, INDEX, MATCH - output help

    I have a formula that uses an IFERROR, an INDEX and a MATCH formula at once. I want to change the output value of the MATCH so if a MATCH is found it outputs a 'YES' rather than the value that is being looked for. Formula is below; =IFERROR(INDEX('[Management Db...
  12. J

    Extracting non zero cells from a data table

    I have a large data table that takes the form of n rows of Reference1 and z columns of Reference2, for each cell there is an output data that is numeric. Many output cells are zero are blank. I need to extract the data relating to the non-zero cells in the form of a simple 3 column multiple row...
  13. S

    User Defined Functions...Trouble With Output Values

    Below is a user defined function i put together to gain flexibly outputting correlation matrix values to a location of my choosing. The problem is, when I enter my data range and click OK I only get one value. The value is a "1" which is a good sign (lies on the diagonal), but when I try to...
  14. S

    Distance Range - Vlookup ???

    Hi Just wondering how I can obtain an output which is based on a range of distances located in two adjacent columns ? EG: Increasing distances as we go down the page - Cell A1 = 5.0 & cell B1 = 5.5 / Need an output to show that these values lay between location "A" and "B" Cell A2 = 6.2 &...
  15. T

    repeat/concat data in a cell based on values in other cells

    I am trying to fill in/update cells based on the contents of a data cell and repeat that pattern for N times where N is the value of another cell. The data cell would contain a string and the match condition would be a the contents of another cell. For example: <tbody> Output A A A Data...
  16. P

    Multiple nested if statements with the =IF(ISTEXT(SEARCH

    So I just started cutting my teeth on some of the more complicated parts of Excel. I want to output one of a variety of text strings in a given cell based on a variety of text strings in a column to the the left. Some sort of fuzzy match would be excellent as well. I'm not using VBA either...
  17. S

    Index Match Date and Month

    Hi, How to index match with date and month ranges. I am looking for two different output based on the following data. 1. Date wise 2.Month wise I apply the following formula in I3==IF(MATCH($G$3,$A$3:$A$1000,0),INDEX(DATA!$C$3:$E$1000,MATCH($H3,DATA!$B$3:$B$1000,0),MATCH(I$2,DATA...
  18. S

    Formula help to eliminate blank cells in a row

    Hi, I don't know VBA and therefore need a formula that can eliminate all empty cells between orders. If you look at the mock source data in the table on the left shows: company, order dates, and quantities. On the right, I'm showing a mock version of the desired output, where a formula finds...
  19. K

    Add a fixed value until threshold is reached. Output is first value after threshold.

    Hi Everyone, first post. I'm generally "pretty good" with excel but I have no VBA experience. Hoping to find a solution to this problem without use of VBA. What I'm trying to do deals with dates, but for the sake of this I'm going to simplify it and I should be able to translate a solution to...
  20. M

    Indirect with unique values

    Hello everyone, i have a situation where i do expect the support. Please find here attached workbook in the provided link. The output in column B in Report tab is not giving the correct result. if the Sales person is getting repeat in the second worksheet then i do expect the search result will...

Some videos you may like

This Week's Hot Topics

Top