bus

  1. I

    COUNTIFS not counting

    Hi I'm learning about COUNTIFS and I don't understand why this is working in one row and not another. In my first cell in question My Criteria is TECH (E4) in Ranges A2 to A20 and R(G4) is ranges B2 to B20 : I'm using =COUNTIFS($A2:$A20,$E4,$B2:$B20,G4) - and it seems to work, it counts 4...
  2. J

    Extract Data from Another workbook , Match data and Paste

    Hello Guys , I am Beginner in Excel VBA . I have 2 Workbooks with Bus Numbers and Locations . Workbook 1 Contains Bus Locations in A ,C,E,G and Bus Numbers in Column B, D,F,H. Workbook 2 Contains some Random Bus Numbers In Column A and Missing Bus Locations in Column I . Workbook 1 gets...
  3. B

    Sort multiple tabs

    Thank you in anticipation. I have multiple tabs on a worksheet that are ordered thus (the numerals are times but set as text): Bus 14.10 Bus 14.40 Bus 15.10 Car 14.15 Car 14.45 Car 15.15 Plane 14.20 Plane 14.50 Plane 15.20 I would like to sort the tabs in TIME order.
  4. B

    Need a formula to return header if cell is not blank and concatenate the header names separated by comma

    <tbody> Car Bus Train Result 1 1 Car, Bus 2 2 Bus, Train 1 No Car, Train 7 3 Car, Bus 10 Yes Car, Train </tbody> Request your help to have a formula in excel to get a result as shown above. Cells could have numbers or blanks or text. if there is any number/text in any cell(s)the...
  5. S

    Sumifs for Data given with multiple columns

    Hi , I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria. For ex : In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June...
  6. J

    Pivit Table top 10

    Hi All, I have searched many threads but cant find the answer. I have a table of how many times a bus has not made its bus stop in time. I want to see the worst 10 bus numbers. I have used the filter top 10 but this shows me about 18 Rows of data in the pivot table, i just want to see the top...
  7. H

    Help Please -Sum off multiple adjacent cells

    Hi, I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms. I need to total the revenue in row D for all lines that have a specific working in Row A B and C See example below: I need a formula to automatically calculate...
  8. T

    Equally split column list to a section of people

    Guys, im pretty sure this is not possible but wanted to check. I have a list of vehicles in column A and a list of 4 names in D1:D4 (dave, bob, jim and steve). I was wondering if it is possible to allocate the vehicles equally to the people named in D1:D4 so each person has an equal amount of...
  9. T

    I need a formula to put in cell C3 that says: If cell A1 > 0, then it equals cell B2 (but if it's blank, it equals 0)

    I hope this makes sense? I'm creating a budget for a tour company that occasionally use bus drivers. I want the formula in C3 to reference cells A1 and B2. If the number of bus drivers (cell A1) is greater than 0 - then I need to add the accommodation costs (from cell B2) to the vehicles...
  10. J

    Excel Help

    Hi All, Hopefully i wont confuse this matter. I have for example a bus timetable. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> 2 3 4 5 2 60 70 80 90 3 70 80 90 90 4 80 90 90 10 5 90 100 110 120...

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