egg

  1. M

    hyperlink error, connected to tab name that changes

    I have attached a link of a screenshot of the workbook I am working on. I will try to describe what I need, but it might be easier to see the picture with it. https://postimg.cc/BLm3d5t4 *in the workbook I have a main "DATA" worksheet & an individual worksheet for each individual egg. So...
  2. L

    Doubt about countif

    Hallo, I've this little problem to solve. I have a list of names in a column. Every name has one of the following values to associate with: 1 or 0.5. - Mr John (value 1) - Mr Morrison (value 0.5) - Mr Morrison (value 0.5) (a single name could be present more times) - Mr X (value 1) - Mr X...
  3. M

    Code for tab name from a cell of a different worksheet in same workbook

    Good Evening, I have been struggling with this macro code for a few days now and was hoping I can find the answers here. I am a zookeeper (birds) and we are changing our Incubator room process to all digital (there is a spreadsheet we use for basic data "egg measurements, parameters for the...
  4. M

    Subtotal using formula

    <colgroup><col><col><col><col><col span="2"></colgroup><tbody> Date Items - Nov'18 Qnty Rate Amt. Subtotal 1.11.18 Executive Non Veg Lunch 2 40 80 80 2.11.18 Chicken Biryani 2 95 190 Chicken Bharta 2 45 90 280 3.11.18 Egg Fried Rice 1 36 36 Chilly Chicken Boneless 1 45 45...
  5. R

    Can't even figure out which function to use here?

    This problem has me stumped because I can't figure out which function to use. This is a basic problem where I have a group of people who were supposed to bring items from a list/array called "Item List" for a cooking class. I need an easy way to compare what they "Brought" to the "Item List" for...
  6. anonymust

    Do not display "0" from other sheet

    How can I get excel to display an cell with nothing in it? I want both columns A and B on (sheet 2) to be the exact same as sheet one. But when I insert the =Sheet1!A1 and when i drag that function down the sheet all the cells on Sheet 1 that have no data comes up as " 0 " on sheet two. I want...

We've detected that you are using an adblocker.

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.
Go back
Back
Top