The LEFT function is bringing back the leftmost characters up to that point. The FIND function is looking for the first instance of a space in the string, and taking one off this value. To find the first word in the string, we have the following formula: To help with this, I've added a space to the end of the search string. The first job is to parse the search string, separating it into its three words. Let's say that the user enters their search string into cell B3. I don't want it to be case or context sensitive. The intent is that they don't know the part number to order or the exact description, so they enter up to three words and it returns all the part numbers with those three words (or some of those words) and the descriptions of thos parts. I am trying to create a function whereby users of my spreadsheet can type in 1–3 words to search a range of parts descriptions (text entries) and pull up their associated parts numbers and descriptions. Reently, Sam asked me to help with a problem. (Basically, take a random number between o and 1, divide it by the day of the month divide it by the month of the year, multiply the result by 10,000 and figure out its decimal remainder. So kids can't get complacent about remembering the order in which the questions appear. My favourite feature is that the ordering of the questions is randomised, and that random order changes each day you open the spreadsheet. The child is given a tick or a cross as soon as they answer the question, and at the top of the screen, they're given a live status (at a jaunty angle) showing their progress through the test. Each question is presented in turn, each question not showing until the child has attempted to answer its predecessor. The second tab presents the questions in a randomised order to the child. Enter the same one twice, and it will double-up the questions for that times table. The first tab allows the parent or guardian to choose the times tables that the child has allegedly mastered. It can be downloaded here: times tables spreadsheet. Not being able to find anything, I decided instead to create something. So if I selected 2, 3, 5 and 10, I wanted a randomised test containing 48 questions – one for each of the 12 multiples within each of the four times tables. I wanted to be able to specify the times tables that she had learnt, and to give her a randomised, exhaustive test containing one question for each one learnt. There are various apps out there that can help, but I was after something that addressed a specific need. My daughter's in the midst of learning her times tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |