add specific item into last item for whole item based on where precede item

**ABDELFATTA** · 07-26-2022, 07:09 AM

Hi
I want adding the item TML for each item doesn't precede items are (TR660,TMN,TTH) and add item TTN for each item precede item is TR660
I put the result in second sheet but I want in the same first sheet. this is dummy data . the real data can contain about 1000 items for 1000 rows
thanks

**kvsrinivasamurthy** · 07-26-2022, 09:01 AM

ARRAY formula in B2, copy down.

Please Login or Register  to view this content.

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.

**ABDELFATTA** · 07-26-2022, 11:16 PM

thanks. could achieve it by vba ,please?

**nankw83** · 07-27-2022, 12:31 AM

Hi ABDELFATTA,

Try below code ...

Please Login or Register  to view this content.

**ABDELFATTA** · 07-27-2022, 04:21 AM

@nankw83 this is excellent !
indeed I'm surprised from this short code can achieve my project.
just question about this line

Please Login or Register  to view this content.

if I want add more than one items how I put multiple items in array I mean if I have TR660,TM1000,TN123 all of theses items should add to them item TTN

**nankw83** · 07-27-2022, 09:42 AM

You can just do it similar to the 2nd line shown below

Please Login or Register  to view this content.

**ABDELFATTA** · 07-27-2022, 10:47 AM

just if it's possible to put multiple words in bracket like this

HTML Code:

I know this is not right way ,but I see some codes put the words in array like this way . is it possible ?
I'm asking just to learning not make the matter is hard

**nankw83** · 07-27-2022, 11:08 AM

I don't think it works this way. However, if you have a many strings that you want to put them in an array, maybe the code can be re-written differently to loop through each element in the array

You can read more about the LIKE operator HERE

Edit: In fact, the square brackets in my code are meaningless after refreshing my memory reading the link above

**ABDELFATTA** · 07-28-2022, 03:25 PM

@nankw83 I will satisfy your answering and use your way as you mentioned in post#6
thanks for your time & answering

add specific item into last item for whole item based on where precede item

LinkBack

Thread Tools

Rate This Thread

Display

add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Re: add specific item into last item for whole item based on where precede item

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to get the next item value based on the selected item in userform listbox ?

[SOLVED] Search for item in multipage and show the item on the specific page + Collection

Select item from dropdown menu, Populate different specific cell with specific item info.

[SOLVED] Formula to sum item costs based on item library

link item from one column to a specific page that references all data on that item.

Automatically Input Cost of Item Based on Item Name?

Taking the next item in a list into 1 of 2 tables based on the previous item time

Bookmarks

Bookmarks

Posting Permissions