Help

KZ351233

New Member
Joined
Oct 15, 2020
Messages
3
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Del Rte Nbrcommit_tmLast Scan Time
85916300012:31:00 PM
33920000010:13:00 AM
41416300012:35:00 PM
70820000011:37:00 AM
5372000002:14:00 PM
72812000010:38:00 AM
72820000012:42:00 PM
71716300010:47:00 AM
41620000011:54:00 AM
72612000010:09:00 AM
49616300010:22:00 AM
43820000012:49:00 PM
Here is what I am trying to do. the above is the data that is much larger than what I posted. I am trying to get the output as follows:
Route number, Total 1030 commitment, total 1200 com, 1630 commitment, 2000 commitment, last scan time <1030 where the commitment was greater than 1030.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

KZ351233

New Member
Joined
Oct 15, 2020
Messages
3
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Route#1030 Commit1200 Commit1630 Commit2000 Commit<1030 in >1030 Commit
33900011
41400100
41600100
43800010
49600101
53700010
70800010
71700100
72601001

this is the output with the info and the report will have close to 14000 entries and the routes will be listed multiple times.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,887
Members
410,643
Latest member
sng
Top