Search results

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.

Please help me to find a solution to my requirements: Basically, I am needing of two functions 1) Function 1 is to make a sequential list based on the ID number. It starts as "Attachment0" onwards (from Attachment0 to Attachment30). If number column has a similar value then 'attach' columns...

Both works. Thanks Narayank991 and Hui! Additional question please: What is the formula to get the sum of number of column C cells based on the entered criteria date. ie, (A11) 1716

Given the following information below where "date", "name" and "code" is column A, B and C respectively, I would like to know the formula that will count the cells of Column B with text based on the date I entered in (A9) which matches column A dates. The result will then shows in cell (A10)...

Thanks. Will try soon and thanks a lot.

Thanks amrit1186... 1) "A1" contains full journal references. 2) "H1" or "H1:H20" contains few selected keywords. 3) "B1" needs to display the texts/words that appear in both "A1" and "H1"or"H1:H20". "B1" should display the text appears on "H1"or"H1:H20" which is similar or found in "A1"...

I am in need of formula that would copy/extract from one column (A2-A4) and show the result in different cell/column (B2-B4) based on the defined keywords (H1). SAMPLE DATA: A2: The boy and girl is walking. A3: the girl is good. the boy is good and tall. the mother is sleeping. A4: Leo...

WOW!!! This is it... Big Thanks.

Thanks for your reply. Yes, a VBA solution or a combination of both is worth trying please.

@Glen. yes and other type of data manipulation like exporting the file as xml with its own fields. @SirJB7 Thanks, @Faseeh thanks, @Narayan thanks... This is really good! I incorporated the codes (see link below) but I think I have it wrong as it requires me to review cell by cell to remove...

Thanks for all your reply. @SirJB7: See requested samples here: https://docs.google.com/file/d/0B4HzoNsXG4s8T2tYWVBqdEJSWWM/edit . I have manually split-ed one sample for reference (see A21). @Faseeh: Thanks. All is good except that the title of the books (Book 1 Title here xxxxxxxxxxxxxx...

I have more than 10 thousands of scientific references placed under one cell and I would like to separate the authors name on another columns. I have searched the site and tried putting different formula to get the result I wanted but cant get it. Appreciate any assistance please. Example...