b1b5

Hello, If i have a series of numbers as per the below, how do i make the lowest value return a 0? A1 - 25 A2 - 36 A3 - 14 A4 - 20 A5 - 6 In B1:B5 i need B1 - 25 B2 - 36 B3 - 14 B4 - 20 B5 - 0 Thank you

On sheet 1, column A1:A5, I have a list of names: Joe, Smith, Mary, Joan, Bill. Column B1:B5 of the same sheet contains reference codes for the names in A1:A5: JSM, SUT, MRE, KIT, and KTM. On sheet 2, column B1:B5, I have a list of codes that includes some, but not necessarily all, the same...

Is there a simple way(or the simplest way) to count the number of rows a merged cell takes up. So if I'm in A1, and cells B1:B5 are merged, I want to be able to say in A1 that merged cells B1:B5 take up 5 rows. Thanx

Hi folks, Is there a way to make a value "stick" in Excel? For example... Let's say I have Cell A1 as =SUM(B1:B5) to add up the cells B1:B5 and display the results in cell A1. Piece of cake. But what I want is for cell A1 to KEEP the sum even if the contents of B1:B5 get cleared. Thank you...