The problem of subtracting the VBA line number Master please enter

I can't fully understand what you mean, what is the standard of "duplicate data", you say that there is no duplicate data in line 5 13, is 13 in line 13 duplicated?

I felt as if I was in a fugue, reading the book of heaven ......

Undo Time Difference = format(Undo Time - Current Time,"d h:mm:ss")

Can you post all the screenshots of your cell content and ** for everyone to diagnose?

replace mid len 3 stealth functions. You can also do it vertically with excel array formulas. **Nian carries the big as follows:

sub repstr()

dim s1 as string, s2 as strings1 = 123456": s2 = 146"

for i = 1 to len(s2)

s1 = replace(s1, mid(s2, i, 1),s1

end sub

Numerical precision problem, when a value is assigned to a high-precision variable, there will be an error, you can define the variable as a variant data type, and let the program automatically select the appropriate variable type to do the calculation.

sub lxx()

dim h as integer 'Total number of rows.

h = 1000 'Assuming that the total number of rows is 1000, change as needed.

dim i as integer 'Define row variables.

dim jfor i = 1 to h

if worksheets("sheet1").cells(i, 2).value = "October" then

worksheets("sheet1").cells(1, 1).value = i

worksheets("sheet1").cells(2, 1).value = i

j = igoto next1:

end if

nextnext1:

for j = 1 to h

if worksheets("sheet1").cells(j, 2).value = "October" then

worksheets("sheet1").cells(2, 1).value = j

end if

nextend sub

This is the bottom minus the top, and the difference is shown after the record above.

select recordtime, (select top 1 maximum power consumption - t.)The maximum value of electricity consumption from table name where recordtime> as result from table name t

select tb1.[recordtime],tb1.[Maximum electricity consumption], tb2

recordtime],tb2.[Maximum electricity consumption], tb2[Maximum electricity consumption]-tb1

Maximum power consumption] from [table] tb1 left join [table] tb2 on in (select max(recordtime) from [table] where recordtime<

Provide a way to:

Suppose you have no other primary key in this table, or the primary key is not clear and the default date is unique.

The name of this table is rtest, the time column is rtime, and the column is rvalue

select ,max(, select rvalue from rtest where rtime = max( )

from rtest r1

left outer join rtest r2

on >

group by, the value taken in this way is something like the date that follows |Preceding date |Difference.

However, the difference in the first line will be null, and you can filter it or convert it to 0 at your own discretion

This query requires the provider of the sql92 standard to support left outer join, which is now commonly used.

If your database is more specific, there will definitely be an easier way, and many databases provide row numbers.

Also, the solution I gave is that the default is that the value may grow negatively, and if you make sure that the growth is positive, then it can be simplified.

create table test (id int,counter int)

insert into test(id,counter) values(1,3 )

insert into test(id,counter) values(2,4 )

insert into test(id,counter) values(3,6 )

insert into test(id,counter) values(4,9 )

insert into test(id,counter) values(5,13 )

insert into test(id,counter) values(6,18 )

insert into test(id,counter) values(7,24 )

insert into test(id,counter) values(8,31 )

insert into test(id,counter) values(9,39 )

insert into test(id,counter) values(10,49 )

insert into test(id,counter) values(11,53 )

insert into test(id,counter) values(12,58 )

select ,

from test a

test b

where = -1

Give you examples and see if it's what you want.

What kind of database is this? Does it support stored procedures?

In fact, there are many ways.

1.For the 2003 version, the row is limited to 65536 and range( can be used"a65536").end(xlup).row, of course, column A must have data, the 2007 version of the row limit is greatly relaxed, to be appropriately changed.

This method is also very useful.

3.Through the multi-no-calculation method, the range and count methods are used to calculate the travel number, so I won't go into details, because the above two methods are better.

Suppose you get column a, ,

irow=range("a65536").end(xlup).row this needs to be if a cycle is ...

for i=range("a65536").end(xlup).row to 1 step -1

if isnumeric(cells(i,1).value) then

irow= i

exit for

end if

next

The row number of the last numeric value in column a.

range("a65535").end(3).row