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 • •...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...