Spreadsheet: 753251d1635327971-translating-dynamic-array-formula-for-ranking-into-power-query-m-code-conditional_rank_power_query
Sheet: Rank

Batch | Step Text | Control recipe | Rank pasted values | Rank with dynamic array formula |  | Batch | Step Text | Control recipe | Rank
14384960 | Printing reference sample labels | 100000000000395235 | 1 |  |  | 14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1 | 1 |  | 14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1 | 1 |  | 14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1 | 1 |  | 14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1 | 1 |  | 14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1 | 1 |  | 14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1 | 1 |  | 14384960 | Taking of reference samples | 100000000000395237 | 1
14733213 | Logbook | 100000000000401798 | 1 | 1 |  | 14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000401798 | 1 | 1 |  | 14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000403402 | 2 | 2 |  | 14733213 | Logbook | 100000000000403402 | 2
14733213 | Logbook | 100000000000403402 | 2 | 2 |  | 14733213 | Logbook | 100000000000403402 | 2
14733213 | Within requirements | 100000000000403570 | 1 | 1 |  | 14733213 | Within requirements | 100000000000403570 | 1
14384960 | Printing reference sample labels | 100000000000400354 | 2 | 2 |  | 14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Printing reference sample labels | 100000000000400354 | 2 | 2 |  | 14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2 | 2 |  | 14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2 | 2 |  | 14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2 | 2 |  | 14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2 | 2 |  | 14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Number approved | 100000000000400940 | 1 | 1 |  | 14384960 | Number approved | 100000000000400940 | 1
14733213 | Logbook | 100000000000403756 | 3 | 3 |  | 14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3 | 3 |  | 14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3 | 3 |  | 14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3 | 3 |  | 14733213 | Logbook | 100000000000403756 | 3
14733213 | Within requirements | 100000000000404116 | 2 | 2 |  | 14733213 | Within requirements | 100000000000404116 | 2
14733213 | Logbook | 100000000000404597 | 4 | 4 |  | 14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4 | 4 |  | 14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4 | 4 |  | 14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4 | 4 |  | 14733213 | Logbook | 100000000000404597 | 4
14733213 | Within requirements | 100000000000404979 | 3 | 3 |  | 14733213 | Within requirements | 100000000000404979 | 3