Hi. I'm trying to make a formula that has the following results

<tbody>

</tbody>

B1 to be A1 but B2 also A1. B3 to be A2 but B4 also A2. B5 to be A3 but B6 also A3.

Thanks for any help!

A | B |

5 | 5 |

12 | 5 |

7 | 12 |

93 | 12 |

56 | 7 |

20 | 7 |

<tbody>

</tbody>

B1 to be A1 but B2 also A1. B3 to be A2 but B4 also A2. B5 to be A3 but B6 also A3.

Thanks for any help!

Last edited: