excel & match & replace

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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