seats

  1. W

    Using an array to calculate in what year to build sport arenas

    I have a data table with cities, build year, number of seats, need for seats and the current number of seats. I am trying to calculate in what year a company should build sports arenas and in what city. I have read about static arrays and I know the size of my array. However, I am not sure...
  2. C

    Find Specific Phrases in a cell and Paste in another cell.

    I have a table with a description in column A. I want to be able to find a specif phrase that is in column D2:D99 and paste is in column C. I have been playing with this formula =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH("1A",A2)))))>0,"1A","") but i haven't figured out to search for a list of phrases...
  3. A

    Count the amount of times criteria appears in a cell

    Hello, How do you count the amount of times criteria (in this case airplane seats i.e. 1A, 11A, 16C, etc.) occur in a single cell. The cell has any number of seats. I can nest the airplane seats in a list or type it in the formula. I have 30 seats of interest. Thank you!
  4. 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...
  5. 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...

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