old post impossible to read

[montecarlo2012]

find duplicates in an array

Hello, I have a dynamic array 1 at (B1:F6845) and array 2 at (I6809:M6845), both are integers only; I would like to compare the array two against array one and highlight the duplicates in the array 2. and at the end of array two the amount of duplicates founded. like in N6846 the total of...

www.mrexcel.com

please

 

[montecarlo2012]

Please I found this one also unreadable

Looping

Hi, everyone, merry Christmas and thanks all you for your time and teaching I got from you. I am practicing a little bit about loops, so trying to sum rows by rows I got this Sub addrows() Dim x As Long 'ROWS Dim y As Long 'COLUMNS For x = 1 To Cells(Rows.Count, "A").End(xlUp).Row For y = 1...

www.mrexcel.com

 

[montecarlo2012]

VBA A code within a loop

Hi. I have a dynamic array at B3:G2650 and in A3:A20 the numbers from 1 to 17. The double-code uploaded here return the coefficient trend line results at J3:Q10 respectively in this frame and the other just highlight the first row of the array on the report. Until here everything is fine. The...

www.mrexcel.com

as well Please

 

[lrobbo314]

This happened when they upgraded the forum. The unrendered portion is just html, so you can copy paste the html code to this website to see the html rendered correctly.

 

[montecarlo2012]

thanks , You mean on testing area?

 

[montecarlo2012]

I see thanks.

 

[montecarlo2012]

Irobbo314 nothing happen
I rather the moderator do it

 

[MARK858]

Or try the link below

HTML To CSV/Excel Converter

Convert HTML to CSV/Excel

convertcsv.com

 

[montecarlo2012]

Do not work but thank you anyway. I think I found to many to take care. sorry

 

[MARK858]

Works for me, although there are some lining up issues

convertcsv (2).csv
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	6826
3	6827	12/02/2014	1	11	14	25	35
4	6828	12/03/2014	2	5	8	32	35
5	6829	12/04/2014	1	2	5	34	36			1	2	5	34	36	duplicate found=
6	6830	12/05/2014	9	11	12	18	28			9	11	12	18	28
7	6831	12/06/2014	10	15	23	29	31			10	15	23	29	31
8	6832	12/07/2014	1	11	14	16	21			1	11	14	16	21
9	6833	12/08/2014	5	10	14	26	27			6	10	14	26	27
10	6834	12/09/2014	3	9	14	16	18			7	9	14	16	18
11	6835	12/10/2014	1	8	10	30	34			8	8	10	30	34
12	6836	12/11/2014	5	10	11	20	36			9	10	11	20	36
13	6837	12/12/2014	3	11	18	29	31			10	11	18	29	31
14	6838	12/13/2014	7	21	23	27	28
15	6839	12/14/2014	4	14	15	25	26
16	6840	12/15/2014	1	13	18	27	34
17	6841	12/16/2014	1	5	22	26	30
18	6842	12/17/2014	3	14	17	23	26
19	6843	12/18/2014	2	10	16	22	31
20	6844	12/19/2014	3	6	21	29	31
21	6845	12/20/2014	4	6	7	20	30
22	6846	12/21/2014	7	10	16	23	24
23	6847
convertcsv (2)