sessions

  1. T

    Find all cells starting with "SS" - Array Formula with Partial matches????

    Hi there, I am trying to retrieve all three of the cells in a range that start with the letters SS (Study Session). The sessions are numbered SS01 to SS30 in a much bigger sheet. <tbody> A B C D E F G H I J K L M N 1 NAME Num Study Num Careers Study 1 Study 2 Study 3 Mon 1 Mon 2 Mon 3 Mon...
  2. S

    Multiple look up in excel

    Dear All I am not a massively experienced excel user and i am struggling to do a multiple look up and return in excel. I have read some posts but have got myself completely confused - apologies for my lack of experience and understanding! I have a list of people that are assigned to sessions...
  3. A

    Counting training records - countifs / Sum fuctions

    Hi Forum I am try to set up a spreadsheet to count our team's training records. On sheet 1 - I have the data in 4 columns as below <tbody> Date Role Staff Member Name Training (mins) 21/09/2018 Admin Staff 1 20 21/09/2018 Technical Staff 2 120 01/10/2018 Admin Staff 3 30 </tbody> On...
  4. M

    Sometimes Copy paste not working when 2 Excel sessions are running

    This is a regular occurrence: have two or more different Excel sheets open. Copy paste may randomly stop working. Workaround is to close one or more other sessions. Does this sound familiar? But above all: any solutions? Thanks!
  5. J

    Counting number of rows if at least one instance appears in one of three columns

    Hi, all, Hoping someone can help me solve this. I have a spreadsheet with four columns (columns are sessions). The rows are weeks. So, I'm using a bullet point to indicate when I've attended any one of up to four sessions in each week. A B C D 1 • x x x 2 x • •...

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