sequencing

I have an Excel 365 worksheet that has a button I want to use to run a macro. When clicked, I want the VBA code to look for column A of the first empty row and generate an MPF Number in the format “MPF-yyyy-####” where yyyy is the current year and “####” starts with “0001”. Each time the button...

Hi there, I am banging my head against a wall trying to have a formula that would instantly count from 1 to 100 and then reset infinitely. I assumed I could do 1 to 100 twice and then use the fill handle but that causes excel to assume I want 1-100, 1-100, 200-300, 1-100 etc Now...

I want to count a mixed sequence of values contained in a single column and show how many of each value occur, in order. Here's some sample data and desired output: Sample data: A A A B A B B A A B Desired output: A 3 B 1 A 1 B 2 A 2 B 1 How can this be done (preferably not using VBA, but if...