excel & match & replace

  1. A

    Custom format cell to consider dash as zero in excel

    I import data from web external query in excel in which zero value represented as dash, to further calculation on this I need to consider this dash as zero for that I have macro to convert dash to zero but, data gets refreshed every 5 min. so I need to run that replacement macro every 5 min...
  2. A

    I need get output using excel formuals

    I Want to get Product value on below table using Excel formula <tbody> <colgroup><col width="73"></colgroup><tbody> 01-01-2016 </tbody> <colgroup><col width="73"></colgroup><tbody> 01-03-2016 </tbody> <colgroup><col width="73"></colgroup><tbody> 01-04-2016 </tbody> A...
  3. S

    Finding and returning a text from list from numerous identifyer given

    Good day kind sir/madams, im in great need of help. I was given a big file for reporting. My dilemma is that i couldnt figure out a formula to where i can search a cell will multiple text and return it with a title from my list. Below is the image from what im working on. The first cell...
  4. T

    Count the first non-zero Consecutive Cells until another 0 appears

    Hi, I'm trying to figure out a way to count the number of cells in the first non-zero Consecutive cells. Been reading all the posts about consecutive cells posts, but couldn't get anything working. Could anyone help? Thanks in advance! The desired results are listed below <tbody> A B C D E...
  5. E

    Overwriting cell with data from another cell

    So my task is to make a fully functioning bill and stock display in Excel. I've completed everything and it all works well except for on little thing. The amount of selected products are to be deducted from the stock on another sheet. And note that it has to be saved afterwards and deducted from...
  6. D

    Keywords match in excel

    Hi, I have a list of keywords in Sheet A (2000 rows) and I have a sheet B (column B), where I want to highlight Column B or get YES/NO (in nearby column D) if the cell of column B contains any keyword. For example - Column B cell contains "30secondMBA.com" and I have a keyword "MBA". If I...
  7. F

    How to conditionally copy value of one cell to the other cells in the same row using formula or macro

    Hi All, I have a data table like this: <tbody> A B C D 1 T 0 1 1 2 G 1 0 0 </tbody> After using formula or macro, it should look like this: <tbody> A B C D 1 T T 1 1 2 G 1 G G </tbody> All 0's has been replaced by the text in the cell from Column A in that row. Have no idea how...
  8. D

    Count occurrences of sequential range values in another range

    Hi there, My example is that on column A, I have different names. Let these be, in order of appearance, starting with <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...
  9. P

    quarter year to date

    i want to convert Quarter year to date.please help. for eg- i have Q1 2010 i will be replaced with 01/01/2010.
  10. V

    Index match formula not matching properly.

    I started with a vlookup but moved to an index match. I am trying to match two columns 1 column has an ID in it the other column has a ^ with an ID. If I put the formula of the cells I get a match but when I use the index match it won't match. I am comparing value from one sheet with values from...
  11. G

    replace the list of words with selected list of words. and change the time automatically

    i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example : <tbody> A(original) B (time changed) C ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4 ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7...
  12. G

    create automated time and replace few keywords excel formulae

    i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example : <tbody> A(original) B (time changed) C ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4 ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7...
  13. G

    i want to mix multiple paragraphs into one paragraph in a cell. the final output should be one article or paragraph in a cell

    hey sir i need your help i want to mix multiple paragraphs into one paragraph in a cell. the final output should be one article or paragraph in a cell. for example : <tbody> A B C a b c abc d e f def </tbody> i guess you understood the thing i want to remove all my carriage returns or...
  14. J

    Data to be split between columns

    I have data in a single cell in the below format 1 NULL 384 JPY 0 2 2 384 555 JPY 0 10 3 555 389 JPY 0 128 4 389 1000 JPY 0 2345 I want to split the data into different columns Like for example C1 C2 C3 C4 C5 C6 C7 C8 C9 0 384 555 389 1000 2 10 128 2345 CAn...
  15. L

    Pulling Rows Between Data Sets Based On Time Stamp

    Last post doesn't seem to have been listed. Can be found here: http://www.mrexcel.com/forum/excel-questions/932840-comparing-2-tables-pulling-row-1-into-other-if-takes-place-within-20-minutes-after-original-date-time-stamp.html
  16. N

    Populate another cell with a description from a list by typing the last word or words in an adjacent cell

    I have a list of Description in Column A eg 1 Computers, Laptops & Notebooks, Laptop Accessories, Laptop Chargers 2 Computers, Laptops & Notebooks, Laptop Accessories, Laptop Cables 3 Computers, Laptops & Notebooks, Laptop Accessories, Laptop Bags 4 Security, CCTV, CCTV Cameras, Cameras IP 5...
  17. D

    Adding a unique name to duplicate values in a column

    Hello, I need help writing a VBA macro that will search for duplicates in a column and add a unique identifier. So that I can mark some, not all for deletion further on in my macro ( I already have that part written out) For Example: <tbody> A 1 AAA 2 BBB 3 AAA 4 BBB </tbody>...
  18. D

    VBA to find/replace information from one sheet to another

    Hello, I am looking for help on writing a VBA that will replace information in one sheet using a legend that is in another sheet. I need two things to happen. 1. replace cells in column C in Sheet1 with data from column C in Sheet2 if column C in Sheet1 = column A in Sheet2. 2. also insert...
  19. D

    VBA to find/replace information from one sheet to another

    Hello, I am looking for help on writing a VBA that will replace information in one sheet using a legend that is in another sheet. I need two things to happen. 1. replace cells in column C in Sheet1 with data from column C in Sheet2 if column C in Sheet1 = column A in Sheet2. 2. also insert...
  20. N

    Bonus calculation

    <tbody> Slabs (Purchases) Discount Applicable on HIGH VALUE PRODUCT 0-99 0% 100-299 1% 300-499 2% 500 and Above 3% </tbody> Conditions: 1. To avail the discount, the purchase bill has to be in the limits mentioned above,a minimum of 100 RO of higher denominations Example below...

Some videos you may like

This Week's Hot Topics

Top