Search results

Thanks for your help Bosco and it works on some address with similar nomenclature/format of the address above however, results are not appropriate given different address/format below. If I have few list of addresses, I can manually fix it however, I have hundreds of addresses and hopefully you...

Thanks AlanSidman. Tried it and helps a little. Hope there is an alternative please.

I would like to extract the postal code from the hundreds of addresses we have on file. The postal code appears in the address in different postition (see sample below). The postal code format starts with alphabet number alphabet number alphabet number (ie H9Y 2Z3) but sometimes written with...

Thanks Bosco.... This is great but I forgot to add the "Sunday" column... sorry for this and appreciate if you could update it please. I tried...

Hi Bosco, It works however I am not able to put it together due to worksheets I have in my actual file. I attached here a new document where you may please incorporate the formula once again please. Thanks for your help.

Thanks Bosco. PM sent.

looking/searching for a right formula that will display a cell on a list based on a given table. A match result will be based on the following criteria: 1) date 2) timing 3) name if it match then it display the time start and time end on a separate list/table. I have attached the sample file...

You are the best. Your code rocks and execute 131k rows in a blink of an eye. Big thanks. Furthermore, willing to wait for a month or so ;-) if somehow the line of codes could be explained for learners information. Thank you.

I need to find two cells that contains text from three columns... Based on the attached sample, I would like to know the formula on how to find and compare data please. Thank you for your help.

Its me again.... I have asked a friend to modified Peter's code but one way or the other, the process still takes so much time (131711 rows) and need to wait for so looong to get the results everytime I run the code, and most of the time, my computer hangs. Is there an altrnative way/code to...

Thanks Peter.

Thanks Peter. Thanks Bosco. I recorded a Macro and run it on the original attachment above and it works Bosco.... Would it be possible to have the code below converted in VBA with an objective that every output/result in each cell will simply contains 'text' and not with "code/function...

Just to bump this thread to whoever can provide an alternative formula for =IF(B2=1,"",LOOKUP(2,1/ISERROR(1/($B$1:B1-(B2-1))),$C$1:C1)) My excel/computer hangs due to a file of mine that contains tens of thousand of rows being processed. Please help.

Hi, additional request with similar issue as I modified the requirement by adding a new "No Order" comment. I need formula/function please. Attached is the file for your reference. Thanks for your help.

Thanks a lot Bosco. It works....

Appreciate if somebody could help me find a proper "If" or whatever appropriate function/formula with several conditions following the requirement as commented (desc column) in the attached file. Please refer to the attached the file for better understanding please. Thank you for your help.

Thank you very much for your reply.

Greetings! I have thousands of items that includes the 'text' and 'date' in one field. I am using pivot table to generate the chart, however it is my desire to have the sequence sorted by the Date as appears in the ItemDate column. Attached is the sample file with few data. It is my intention...

Great! Thank you Bosco.

Good Day! I am receiving two files from different department and usually copy/paste them on separate worksheets within my master file. -----WorkSheet1------ FRUIT STARTsupplyDate STARTprodDate STARTfinalDate BANANA 1/1/2017 2/2/2017 3/3/2017 ORANGE 4/4//2017 5/5/2017 6/6/2017 APPLE 7/7/2017...

Thanks @Asheesh and @Ashhu. Both works and issue solved. Big Thanks.

I have three columns (b1,c1,d1) with similar data/text and would like to know a formula that would result as example below. I must combine/put (b1,c1,d1) content into one cell (a1). A1 B1 C1 D1 Kuwait Kuwait n/a Kuwait France n/a France n/a Saudi Arabia n/a n/a Saudi Arabia Thank you in...

@Hui, column A is manually added, just to get an idea of the objective. It is a result of condition from Column B and C. Thanks. @ Shrivallabha, Amazing! it works exactly as required... SOLVED ;-) Big thanks Shrivallabha.

Greetings! I have a thousands of item that requires me to identify which item is part or belong to what item/level. I have attached an excel sample where a) Column B (level), C (Item Number) and D (DESC) are the given data. b) Column A is the output/result that I would like to have which...

Big Thanks Narayanan. You got it right.. By the way, is there a way to have the result all in one row (see sample attached). result could be put in another worksheet or somewhere.