anne

  1. B

    Conditional Lists

    Hi Members I am trying to create a spreadsheet for our tennis club, We may have members that play on multiple teams , on our calendar to schedule matches I would like to be able to restrict the drop downs if a player team is selected then any other team that they play on can not be selected...
  2. J

    Sumif sumifs exact match

    I have 16,000+ rows in my spreadsheet, and over 100 names in column A. I need the total in column C to be cumulative at that point, not in total. For example, Anne at row 3 column C is 40 and not 60. If I sorted by A and B, smallest to largest, column C should be 20. Please help! Thank you...
  3. J

    Windows Environ restricting access

    Hi I have searched high and low for this solution... If I have 4 sheets in a workbook, named Summary, Anne, Jay, Simon. I am looking for Anne to view only her sheet, Simon to view only his sheet, and Jay to view all.... (Their names could be in cell A1 of each of their sheets). How would I do...
  4. T

    Some sort of Vlookup, sumproduct

    Hi Board, It's been so long since I've done this I've forgotten how! <tbody> A B C D E Owner First Name Surname Name Owner Anne Joe Bloggs Joe Joseph Bloggs ANother </tbody> For ease I have put this data on one table, however, the data is split across two tables in two sheets. So...
  5. C

    VBA Deleting ListObjects Rows With Hidden Columns

    I am writing a macro to delete all rows of a ListObject table not matching a specific value, so that the resulting table is left only with the value I want to keep. I am running into problems when the first or last column of the table is hidden, and cannot figure out what is going on or what...

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