title: Find Last 4 Max Number from Alphanumeric Vlues in Excel
body: <p>I'm working on a sheet in which i have to keep record of my cartridges used in machines. <a href="https://i.stack.imgur.com/ABlrR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ABlrR.png" alt="enter image description here"></a> </p>
  
  <p>Every Machine use 4 cartridges at a time Marked as "In Use" in Data table. Now I'm trying to get all 4 "In Use" cartridges IDs of every machine separately in "In Use Cartridges" Table. I've tried many formulas but get only Max Value only. Please help me on this. Also i cant use VBA in my sheet just only need formula solution. Thanks in advance.</p>