insert row TOTAL after the last row for duplicates items based on column

**leap out** · 03-21-2022, 06:56 AM

hello
I have data in sheet summary . in column B there are many duplicates items. so what I want insert row TOTAL after last row for duplicate item . and if there is no duplicate item also should insert TOTAL row after the non duplicate item based on column B . I put the result in second sheet .

**Bo_Ry** · 03-21-2022, 08:48 AM

Please try

Please Login or Register  to view this content.

**leap out** · 03-21-2022, 09:03 AM

great ! just I want to fix the word TOTAL . this word shows when the language of PC is English . if it's not then shows based on language of PC .
I would always show TOTAL regardless what's the language for the PC .

**Bo_Ry** · 03-21-2022, 10:02 AM

Try

Please Login or Register  to view this content.

**leap out** · 03-21-2022, 10:16 AM

thanks , but I note the sequences don't arrange again after insert TOTAL row as I put it in sheet OUTPUT should be 1,2 ,3... for each part .

**Bo_Ry** · 03-21-2022, 10:34 AM

Last try

Please Login or Register  to view this content.

**leap out** · 03-21-2022, 11:31 AM

Last try

excuse me ! I do not want to disturb you every time, but I have ever put the whole my expected data in sheet output and I don't ask new requirement . just for clarification .
your last code works excellently !

thanks very much .

insert row TOTAL after the last row for duplicates items based on column

LinkBack

Thread Tools

Rate This Thread

Display

insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Re: insert row TOTAL after the last row for duplicates items based on column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] count duplicates items in specific column up to 90000 items

insert row for new items before TOTAL row based on matching between two sheet

[SOLVED] insert TOTAL row and summing for each items

[SOLVED] insert row and fill data before Total row based on match the column

Count Total of items in a column w/o counting duplicates or blanks

Need Help to insert rows based on multiple criteria in same column and give total and sbtl

Insert Total row if duplicates exists

Bookmarks

Bookmarks

Posting Permissions