Keep or store rows for each non-repeated name

**KingTamo** · 03-11-2023, 05:44 AM

Hello excel experts

In the first worksheet, there are values from range("A2:F" & lr) where lr is the last row based on column A. In column D, there are names (the names are repeated). I need to build a dictionary for the unique names (column D) which will be keyed. Each key should store a 2d array of the rows related to that key.

I found that code but I got errors on this line [ReDim Preserve rows(LBound(rows) To UBound(rows) + 1, 1 To 6)]

Please Login or Register  to view this content.

**Sintek** · 03-11-2023, 06:01 AM

sample file and expected output?

**KingTamo** · 03-11-2023, 06:08 AM

No specific output. I just want to build a dictionary with the unique keys from column D. and later we can loop through the keys and retrieve the stored rows.

**Sintek** · 03-11-2023, 06:14 AM

From experience you should well know that previously, code has been supplied, and YOU are not able to adapt it to fit your actual file...
Hence, so as not to waste time, upload a sample file and explain what it is you are wanting to achieve...

**KingTamo** · 03-11-2023, 06:15 AM

The code is well but there is a problem with the ReDim Preserve statement. No specific output sir sintek. just wanted to store the related rows to each unique key.

**KingTamo** · 03-11-2023, 06:37 AM

Sample of information:

col a --- col b --- col c --- col d --- col e --- col f
**************************************
aa --- bb --- cc --- ITEM1 --- ee --- ff
aaa --- bbb --- ccc --- ITEM2 --- eee --- fff
a1 --- b1 --- c1 --- ITEM1 --- e1 --- f1

The desired output
***************
ITEM1
aa --- bb --- cc --- ITEM1 --- ee --- ff
a1 --- b1 --- c1 --- ITEM1 --- e1 --- f1

ITEM2
aaa --- bbb --- ccc --- ITEM2 --- eee --- fff

**jindon** · 03-11-2023, 07:35 AM

Please Login or Register  to view this content.

**KingTamo** · 03-11-2023, 07:43 AM

Thanks a lot sir jindon. Is it probable to modify the first code that uses a dictionary?

**jindon** · 03-11-2023, 08:49 AM

that code doesn't make sense to me

Please Login or Register  to view this content.

**KingTamo** · 03-11-2023, 09:14 AM

Amazing code sir Jindon.

**KingTamo** · 03-11-2023, 09:21 AM

I noticed each block of results consists of the name as a key and the related rows. That's great.
How can I add another row (the headers) to be the second component
I mean the key is the first element. The header row is the second element. The third element is the related rows.

**jindon** · 03-11-2023, 09:26 AM

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**KingTamo** · 03-11-2023, 10:10 AM

Excellent. Thank you so much.

Keep or store rows for each non-repeated name

LinkBack

Thread Tools

Rate This Thread

Display

Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Re: Keep or store rows for each non-repeated name

Thread Information

Users Browsing this Thread

Similar Threads

Help! sum repeated rows

Rows to be repeated at the bottom

[SOLVED] Moving data from Rows to columns and delete repeated rows

Macro to store results of repeated calculation

Remove repeated rows.

sum once for repeated rows

Deleting repeated rows

Bookmarks

Bookmarks

Posting Permissions