Jump to content

TomHD

Members
  • Posts

    598
  • Joined

  • Last visited

Reputation

3,321 Excellent

About TomHD

Personal Information

  • Occupation
    Network Manager - Primary Education
  • Location
    United Kingdom
  1. I'll second the first response... expensive, yes, but they do offer excellent support and have quickly solved every issue I've ever had. They even managed to fix a broadband issue we had that was nothing to do with RM/CC4, this was after numerous visits from our broadband supplier who couldn't find or fix the issue
  2. Yeah no probs, probably better to pop me a PM for anymore, save cluttering the forums best of luck
  3. No probs, you were really close let me know if you get stuck on the "C" function
  4. On the "make_pigeonholes", in the final repeat loop, change "set number to item i of pigeonholes" to "set number to item i of unsorted_list" you were basically setting "number" to the empty value in pigeonholes where you wanted to actually set the value from unsorted_list Whilst working on the scripts its worth showing the variable on screen as that helped me to see that "number" was never set to anything Get the M function working first
  5. Can you zip up your Scratch file and attach to the thread please?
  6. for kostascoffee 2 single index variable.zip this example only uses i for indexing compare the 2 examples to see how that works
  7. i, j and k are indexes for looping through the lists. You can just use i and reset it to 0 before each loop but by using different letters you can see where and how they relate to each loop hope that helps? You can remove L completely as it is not used in my example
  8. Try this... for kostascoffee 2.zip The wording was clear enough imo NOTE: you can delete variable "l" as it is unused!
  9. Try this...for kostascoffee.zip
  10. @rush_tech the example I attached does use both names to do the check? for rush_tech.xlsx To expand a little on the solution... =VLOOKUP(A2&B2,$I$2:$L$4,4,FALSE) A2&B2 create the single lookup value by concatenating firstname and lastname, we then create a "Lookup Helper" column in the range we are looking up, that is why we start at I2, as column I is our helper, which is a concatenation of J and K [=CONCATENATE(J2,K2)], the formula then uses the A2&B2 value and looks for it in column I and returns the email value in column L [column 4 of our lookup range] on the same row where I matches A2&B2 We enclose the range in $ so that those numbers and letters do not change when copying down
  11. Try this in cell D2 then copy down... =VLOOKUP(A2,$J$2:$L$3,3,FALSE) You don't need to reference column M as it is empty So the above formula only works if there are no duplicate first names... have fixed that in the example attached below, let me know if this is what you were after for rush_tech.xlsx When doing VLOOKUP on 2 cells you need a helper column where the 2 values are concatenated and then used to compare to the range in the lookup, hope this explains it well enough!?
  12. Have you contacted the supplier on Alibaba yet? I have had some success with getting orders below the minimum order by making contact, just expect to pay a little more per unit
  13. We expect TAs to take registers for student and supply teachers.
  14. Same as @Rob_D, we give students teachers the same access as regular staff but do not include RD or SIMS access
  15. Did you try the setting "Print as image"? Also drop Adobe Reader and install Foxit Reader if you are in a position to
×
×
  • Create New...