seat

  1. M

    Seat Allocation formula

    Hi, need help on how to use Excel to meet below requirement. Below sample is just small population of total seatings so would need to automate. Appreciate your help please, thank you!!! =) Requirements: 1. Allocate the Box capacity following the Position hierarchy, such that "Head" starts to...
  2. N

    Parentheses Problems

    Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL...
  3. P

    Help with ISERROR function.

    Hello all. Here is the scenario. I am using Excel to track the inventory of desk phones(among other things) This screenshot is row 8. Here is what I currently have for the H Column =IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"") The phones are assigned to a particular seat or...
  4. V

    Assigning sequence of numbers to visible cells only using VBA code (avoid hidden rows)

    Hello, I am having difficulty with assigning a specific sequence of numbers (seat numbers listed below) to specific records whilst keeping the order. For context, I have a running order of graduands and those known to be attending are marked as attending in column C as well as the row being...
  5. C

    Simplifying Code

    Hi, First of all thanks in advanced for your help. I'm fairly new to coding VBA in Excel. so I have managed to create the following code (which works as intended) and I am curious to know if there is anyway to simplify it as I need to add more lines to it. The intended result is that when a...
  6. C

    Help with IF statements and updating multiple cells.

    Hi, I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which...
  7. C

    IF statements and updating other sheets

    Hi, I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which...
  8. S

    Maybe VLOOKUP? Help sorting based on dates

    So, I'm trying to get the latest information based on dates for flying. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col...
  9. T

    Pivot table data layout

    This is embarrassing but hope this is because I've been a bit rusty on excel vs it being an excel issue. Here's the data set I'm trying to make a pivot table out of the following data set.... <tbody> Time on Seat Did you like onboarding? Did you do your hw? Was he helpful? Did He help when...

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