Recent content by tango

Thank you so much vletm. Thank you AlanSidman as well...

this works. hope you dont mind to explain on how can I use or incorporate the code/macro to my working file please. You can even show the result on a new tab please.

I have hundreds of rows that shows employees absent date and I would like to have it reformatted on a list that shows the absent date in rows per day. I have attached the file as well. Please help and thank you in advanced. Sample: Person Name Blank2 Abs-Code From Blank3...

Great.... Thanks vletm... Appreciate the feedback. 1) Would it be possible to create/include a header too. 2) I have tried adding rows (or have level number 6) but the result remain the same or it does not include new list/rows and create new column for that level. 3) instead of replacing cell...

Hello, I would like to generate or extract data into an individual 'column' from my list based on a number of one column. I have attached a sample file with two tabs. DATA tab contains the list, and RESULT tab is what I expect to get. In an actual environment, the level is not defined or...

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.