![]() Next day morning, as usual Homer messed up something and you had a new repair to log. You whistled your way to home that night. So you add a new column called Same? and want to fill it up with a simple relative reference formula to check with Machine in row 1 matches machine in row 2.Įxcel automatically filled down the formula for all rows of the table, because tables are awesome like that. You are the kind of person who frowns upon manually highlighting yellow color in cells to flag such successive failures. ![]() For example, in above picture, you notice that MACH-0038 failed twice in a row starting with 11th of March. Chandoo says tables are sweet’Īfter a few days of tracking the repairs, you wanted to know if same machines are failing successively. ‘ Gee whiz, I might as well use tables to maintain the repair log. Since you heard Tables are mighty, you thought, To keep track of which machines are under repair, you maintain a repair log in Excel. Although your machines are mighty, sometimes they do fail. Imagine you are the machine supervisor at Mighty Machine City Inc. Today let’s examine one such unique problem and learn about an elegant solution. While tables are super helpful, they do come with some limitations.
0 Comments
Leave a Reply. |