+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Return Column Heading in Technical; Hi dont know if anyone can help On the attached document, I need Admin Sheet Cell C11 to C18 to ...
  1. #1
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Return Column Heading

    Hi dont know if anyone can help

    On the attached document, I need Admin Sheet Cell C11 to C18 to look at Teams Attendance sheet and return tournament names that they are missing!

    As you will be able to see i have managed to do this with an IF Formula, but it only looks at the first argument if there are multiple results.

    Need it to say Pennine C tournament 1, tournament 2.


    Any help Much Appreciated

    thanks

    James


    Book1.xlsx

  2. #2


    Join Date
    May 2009
    Posts
    3,212
    Thank Post
    284
    Thanked 865 Times in 646 Posts
    Rep Power
    336
    Since you want them all listed - why you don't just reproduce the grid? If you really really want them in two cells, consider reproducing the grid somewhere else, twice!. Use an IF to populate the grid with the text you want, i.e for attednance

    =IF('Teams Attendance'!B3=0,"","Tournament 1,")

    and for non attendance


    =IF('Teams Attendance'!B3<>"","Tournament 1,","")

    So you now have two grids which display the text you want for each 'listing'. Note the seemingly extraneous comma!

    For the listing all you need to do is concatenate these together :

    =Concatenate( <cell1>,<cell2>,<cell3>,<cell4>,<cell5>)

    Each one contains a comma so if there are more than one they will separate but you need to just wrap the concatenate in a LEFT string function to trim off the last comma.
    Attached Files Attached Files
    Last edited by pcstru; 31st October 2011 at 09:03 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 6
    Last Post: 23rd December 2010, 06:54 PM
  2. LiteOn UK warrenty returns.
    By Dos_Box in forum General Chat
    Replies: 15
    Last Post: 15th December 2005, 02:47 PM
  3. A quick heads up for Lancashire schools
    By Dos_Box in forum General EduGeek News/Announcements
    Replies: 2
    Last Post: 7th November 2005, 05:59 PM
  4. Replies: 17
    Last Post: 3rd October 2005, 07:26 PM
  5. Head on over to surveys
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 4
    Last Post: 20th June 2005, 08:33 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •