Convert Excel IF command to VBA

[krass]

I have af growing Worksheet (daily update) which has an IF command (in Col L) to calculate the difference between two cells in Col E - but only if value in Col A is identical. The IF command looks like this: =IF(A2<>A1;E2-0;E2-E1) and is placed in Col L

If the worksheet has been sorted eg. by Date, it would be nice to have it sorted by User number first, else, I believe nothing would work?

	A	B	C	D	E	F	G	H	I	J	K	L
1	User	District	Date	Number	Consumption	Temp1	Temp2	Temp3	Temp4	Temp5		Diff
2	100	1	27-07-2018	78017332	0,199	32,59	63,43	30,48	38,6	-8,12	-0,0162	0,199
3	100	1	28-07-2018	78017332	0,205	32,7	63,27	30,61	38,6	-7,99	-0,0164	0,006
4	100	1	29-07-2018	78017332	0,209	32,62	63,34	30,49	38,6	-8,11	-0,0169	0,004
5	100	1	30-07-2018	78017332	0,215	32,6	63,32	30,51	38,6	-8,09	-0,0174
6	100	1	31-07-2018	78017332	0,223	32,78	63,42	30,6	38,6	-8	-0,0178
7	100	1	01-08-2018	78017332	0,226	32,66	63,36	30,59	38,6	-8,01	-0,0181
8	100	1	02-08-2018	78017332	0,234	32,77	63,36	30,46	38,6	-8,14	-0,019
9	200	1	01-07-2018	78171036	0,014	29,36	60,98	31,71	39,2	-7,49	-0,001
10	200	1	02-07-2018	78171036	0,025	29,45	60,27	30,14	39,5	-9,36	-0,0023
11	200	1	03-07-2018	78171036	0,039	29,42	60,53	29,82	39,2	-9,38	-0,0037
12	200	1	04-07-2018	78171036	0,052	29,42	60,53	30,26	39,2	-8,94	-0,0046
13	200	1	05-07-2018	78171036	0,069	29,96	60,61	30,3	39,2	-8,9	-0,0061
14	200	1	06-07-2018	78171036	0,091	30,45	61,09	30,35	39,2	-8,85	-0,0081
15	200	1	07-07-2018	78171036	0,112	30,57	61,59	30,48	38,9	-8,42	-0,0094
15	200	1	08-07-2018	78171036	0,135	31,04	61,76	30,48	38,9	-8,42	-0,0114
17	200	1	09-07-2018	78171036	0,153	31,03	61,79	30,42	38,9	-8,48	-0,013

<tbody>
</tbody>

 

[jmacleary]

Hi there

I'm not sure I understand the question - couldn't you sort on column A first then column C? The formulas should look after themselves.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1065545-if-command-loop-into-vba.html#post5117246

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).


Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.