R
rdraper
Hi,
Little help please,
with best technique to perform multiple calculations.
A1 FileNum Customer (TotalWorkOrders by Customer)
---------------------------------------------------
A2 04555501 Acme
A3 04555502 Acme
A4 4555503 Acme
A5 04123401 BBB
A6 04123402 BBB
A7 03111101 XYZ
A8 31111101 xyz
I'm trying to calculate;
the total number of work-orders by customer, where a workorder can have
multiple projects associated with it.
The work-order must be extracted or derived from the FileNum column
The 8 digit FileNum is made up of three components.
04-5555-01 (year-workorder-project)
This is where I need help, can I do this in one array formula?;
1. custom format? to add leading zeros to those without.
2. Extract work-order by Triming leading## and trailng## ,sometimes###
3. Count equal workorders only once
4. Sum the number of work-orders conditional upon customer
I know how to use the functions individually, but am confused as to
grouping them in one formula.
eg. Trim/Count/Sum IF "criteria1"="criteria2"
grateful for any ideas on best practice,
bobd
Little help please,
with best technique to perform multiple calculations.
A1 FileNum Customer (TotalWorkOrders by Customer)
---------------------------------------------------
A2 04555501 Acme
A3 04555502 Acme
A4 4555503 Acme
A5 04123401 BBB
A6 04123402 BBB
A7 03111101 XYZ
A8 31111101 xyz
I'm trying to calculate;
the total number of work-orders by customer, where a workorder can have
multiple projects associated with it.
The work-order must be extracted or derived from the FileNum column
The 8 digit FileNum is made up of three components.
04-5555-01 (year-workorder-project)
This is where I need help, can I do this in one array formula?;
1. custom format? to add leading zeros to those without.
2. Extract work-order by Triming leading## and trailng## ,sometimes###
3. Count equal workorders only once
4. Sum the number of work-orders conditional upon customer
I know how to use the functions individually, but am confused as to
grouping them in one formula.
eg. Trim/Count/Sum IF "criteria1"="criteria2"
grateful for any ideas on best practice,
bobd