Large excel file I m trying to find duplicates and copy the rest of the cells across the duplicate to the duplicate it finds

0 votes
There are 65,000 pieces in my enormous excel spreadsheet; their part numbers are in column A. The part number is followed by numerous columns of crucial information (B is retail price, C is my cost, D is the weight, E description and so on until J) I recently received a list of 16,000 new parts that have been replaced older ones. The new list only includes the new part number in column A and the older one in column B.

The information from the columns next to that A cell should be copied into the columns next to this duplicate if B65001 matches anything in columns A1–A65000, but I'm not sure how to do it.
Oct 28, 2022 in Others by Kithuzzz
• 28,520 points
127 views

1 answer to this question.

0 votes

Copy the column from the other sheet into the one where you wish to search for duplicates. Write this straightforward formula, but divide the database into smaller sections to prevent system lag.

=IF(COUNTIF($A$2:$A$8, $A2)>1, "Duplicate", "")

Use this array formula to count Duplicates,

=ROWS($A$2:$A$8)-SUM(IF( COUNTIF($A$2:$A$8,$A$2:$A$8)=1,1,0))
answered Oct 28, 2022 by narikkadan
• 52,760 points

Related Questions In Others

0 votes
1 answer

How to find out how many rows and columns to read from an Excel file with PHPExcel?

Solution: $file_name = htmlentities($_POST['file_name']); $sheet_name = htmlentities($_POST['sheet_name']); $number_of_columns = htmlentities($_POST['number_of_columns']); $number_of_rows ...READ MORE

answered Oct 23, 2022 in Others by narikkadan
• 52,760 points
1,432 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 52,760 points
148 views
0 votes
1 answer

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

answered Oct 27, 2022 in Others by narikkadan
• 52,760 points
78 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 52,760 points
114 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 52,760 points
96 views
0 votes
1 answer

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 52,760 points
155 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 52,760 points
157 views
0 votes
1 answer
0 votes
1 answer

Uipath(RPA) : read data from the PDF file and write to Excel file

If you want to use UiPath and ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 52,760 points
173 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP