If possible, I'd like to have Excel insert a number that increments by one in the first column of every new row in a given table like so:
GID FN LN
800 John Smith
801 Jill Rogers
802 Sam Spade
803 Sally Spade
804 Bill Bayes
but that will also allow for manual...
Hi everyone,
I've always been a big fan of Mr. Excel's YouTube videos and thought I'd participate in the forum as well. My first post is in relation to the project I am working on. I am hoping somebody could help me out. Been searching for hours on the web and stumbled upon some possible...
Hello everyone! Help! :confused:
1. There are 61 cattle due to give birth in 2016 and then one calf per year thereafter.
2. There is a 45% chance of those calves being female.
3. Of those calves being female, they too would be in a position to reproduce once two years old, again having a 45%...
This answer may exist and I just don't know the right combo of Google search terms to find it because I've tried everything!
I have a "to do" list and I want to add a unique index number for each new entry BUT I'm going to be sorting the list for due dates and priorities. How can I...
I am trying to create a formula that will allow me to refer to the cell one below and one right of the column previously referenced (basically data in a diagonal line) in a new sheet in that workbook. Any help is appreciated--thanks!
Here's a simplified version of what I'm trying to do...
In my workbook, I am calculating the collection of oil and water on an hourly basis and subtotaling on a 24 hr basis for several days/weeks in a row. I need the subsequent sheets after the first 24hr sheet to continue their formula and 'carry over' the previous sheets data. I've done this...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.