person1

  1. P

    Days/rows since 'certain value' for individuals

    Hi, running PowerPivot in excel 2016, say I have a group of 10 persons, and for every day the 10 persons record a score. I'm wanting to find how many days (or rows given that each row is a different day for the individual person) since each person recorded a score of say 60. So in the example...
    • PerryN1
    • Thread
    • person person1 person2 person3 score
    • Replies: 0
    • Forum: Power Tools
  2. carabale

    Entering Different Cell Values into one Cell

    I have a worksheet with different names. Each name might have 1 to 5 rows with comments. I want all the comments on the first line. For example: SSN NAME COMMENT COMMENTATOR 001 PERSON1 COMMENT1 JUDGE1 001 PERSON1 COMMENT2 JUDGE2 002 PERSON2 COMMENT1...
  3. A

    How to?: Daily printout of unstaffed shifts

    Hi all I have a table, pasted below, which shows the daily cover status for different areas at work. I need a way (perhaps VBA) to automatically print / generate a table showing: 1) Today only 2) Listing the ones without cover in the AM 3) Listing the ones without cover in the PM (examples two...

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