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


    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...

Some videos you may like

This Week's Hot Topics