breakfast

  1. Collington

    Creating a daily register based on a different worksheet

    Hey folks, Can you help me with a question for my school? We have children who attend breakfast club. On one sheet we list ALL the children and how many days that term will attend breakfast club (e.g. 5 Mondays, 6 Tuesdays) - this is so we can bill correctly. I want this to automatically...
  2. G

    MODE for text with multiple criteria

    Hi there, I was hoping someone can assist me in crafting a formula that would look at text and return the most frequent appearing text provided it meets certain criteria. Example data set: <colgroup><col><col><col></colgroup><tbody> Category Sub-category Data Breakfast Light Good...
  3. rjbinney

    Tagging Data in Excel

    I don't think "Smart Tags" are my answer here. I have a column with lots of anecdotal data in it, and I would like to be able to sort it into various buckets. I can add columns for each "bucket", and either have it checked or not, but that seems like overkill. Is there a way to just add tags...
  4. R

    Auto Import Specified Data from one sheet t another

    Hi, I would like to accomplish the following; Workbook1 <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 100px"><col width="113"><col width="100"></colgroup><tbody> #B7B7B7[/URL] , align: center"]Meal...
  5. M

    Extract data from Columns and rows

    Hi everyone and thanks for reading this message I hope it makes sense. I have this exercise I found on the internet in which i need to return the price of the breakfast in a chart depending on the room type and Hotel Category. Basically I need to multiply the "Breakfast price" with the...
  6. Z

    calculate time included break

    hi, I have datetime in cells A1:D1 A1: 2018-12-03 06:00 (day work start); A2: 2018-12-03 10:00 (breakfast break start); A3: 2018-12-03 11:00 (breakfast break stop); A4: 2018-12-03 15:00 (day work stop); So normally this is 9hrs work day with 1hr break included. The workers are payed for 8hrs...
  7. D

    Auto-Add New Comment to Cell With Content

    Hello! Is there a way to automatically add a comment to a cell within a certain range if the cell has content? Here is an example of what I mean...(I cant share the actual content, so hopefully this example explains my idea) I set up a calendar to keep track of food that is eaten. If a person...
  8. R

    Count if matches criteria?

    I'm sure Excel can do this, and you folks have saved my hide in the past so here we go! I've fussed a bit with countif and vlookup, but I have a new wrench thrown in today. I have a worksheet and I am trying to get it to count if data is entered into one column based on if a specific text is...
  9. V

    countifs

    My spreadsheet is an on-site catering database. In this spreadsheet I have the date of the meeting, the vendor/vendors that are used for the particular meeting, these meeting maybe a breakfast, lunch, or dinner meeting and there may be multiple vendors per meeting. For example I have 2 columns...
  10. M

    Need to sum Breakfast, Lunch and Dinner per day

    Hi wondering how can I get the total expense of Breakfas, Lunch and Dinner per day. Example of table below: <TABLE style="WIDTH: 312pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=415><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 52pt...

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