simultaneous

  1. A

    Highest simultaneous occurence at a time

    Dear all, I would need a formula which gives the highest simultaneous occurence. In this simplyfied example it would 2 for "A" and 1 for "B" Seems easy but I don't grasp it. Thanks very much ... Arjen <colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt...
  2. L

    MAX and MIN Simultaneous Room Coverage Times Per Day

    Please help. Looking for an equation that will calculate the Max concurrent rooms in column D between each start and stop date/time. Column D has what the correct answer would be. If possible would also like the MIN in column E which also has the correct answer. Correct answers are included to...
    • laneglobal
    • Thread
    • concurrent correct room coverage simultaneous time between dates
    • Replies: 9
    • Forum: Excel Questions
  3. H

    Simultaneous nummber

    Hi! Value of range: A1=1 A2=2 A3=4 A4=5 A5=7 A6=6 A7=3 I want to know if value of range A1:A7 is simultaneous? I mean if the value is 1,2,3,4,5,6,7. In case above, cell A3 should be 3, and the macro must give a msg box "The cells are not in simultaneous". Tanks for help.
  4. S

    "Expected In": Error within a For Each loop

    Greetings, What are the limitations for establishing ranges using "For Each" loops? I am receiving an "Expected In" error on the line below. I am going to be stepping up the sheet but would like the last test integer value to occur simultaneous to the second row value. How is best to do...
  5. E

    simultaneous scrolling among certain sheets

    Hi all, Is there a VBA code to have Excel scroll simultaneously among different sheets (not all sheets, only specific ones)? I would need something like the below but without having ALL sheets move their position... Sub SynchSheets() ' Duplicates the active sheet's cell position in each...
  6. C

    Updating Pivotfields from a Data Validation list across multiple Pivot Tables on Multiple sheets

    Hello I have an issue that i have been playing around with my self for quite sometime now. I found a code that should work but for some reason it is not working and I haven't a clue why. Any help would be appreciated. Goal : Code that will take a drop list and modify the pivot filters on...
  7. R

    Simultaneous while decrement (yep I searched)

    We have about 200 rows of data. Each row is a day. Column A values come from other formulas on that row. Column A values range from 0 to 20 Each new entry in column A contributes "1" to the total in column B for each row until it (A) has decremented to 0. Each entry in column A should decline...

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