Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.

    The Warming is coming. The ocean ice they have lived and hunted on for generations is melting, and they must flee to the safety of an unknown land before they all drown. In this powerful tale of survival at the end of an Ice Age, the young hunter, Attu, must choose between saving his clan or saving Rika, the golden-eyed healer he is forbidden to love.Show more Show less --------------------------------------------------------------------------------

    But after years of harsh treatment by her foster family and memories that seem to hint at an unthinkable crime, Maggie is forced to strike out on her own to separate the facts from the lies.

     Embark on a deeper dive into the mermaid lore of Born of Water, An Elemental Origins novel. New mermaid, Targa MacAuley, has just sat down to read the diary of an ancestor, join her as she uncovers secrets from the past resulting in a tragic shipwreck. More than one-hundred-fifty years later, the wreck gives up her secrets.Born of Water is the first book in The Elemental Origins, a series of captivating YA urban fantasy novels. If you like new twists on mermaid lore, simmering romance, and close-knit mother-daughter bonds, then you’ll love A.L. Knorr’s nautical adventure. Embark on a deeper dive into the story's lore with The Wreck of Sybellen, a companion novelette. Read Born of Water and The Wreck of Sybellen to submerge yourself in an enchanting coming-of-age tale today.

    DI Andy Tregunna is faced with the task of leading the investigation, but soon personal matters force him to step back.On compassionate leave and with little else to do than fight his own demons the unsolved case becomes more and more an obsession to him. As he is drawn deeper into a dark world of secrets, lies and revenge, his private investigation collides with his personal life.The truth is even more sinister than can be imagined...

    With over 600 5* and 4* reviews – you can now buy the first three books in the series for the price of two! Somewhere to Hide (Book 1, The Estate)Cath Mason has learned to be tough. The things she’s seen growing up on the Mitchell Estate, she’s had to be. Yet, even broken and beaten by life at times, she’s still the first person a woman in need of help seeks out. At Cath’s house, there is safety in numbers as well as a place to hide. No matter what trouble comes to her door, she won’t turn anyone away – because she knows what it’s like to live with secrets. But now a problem from her past has come back to haunt her, and she’s the one faced with a dilemma. What should she do first – help or be helped – despite being unsure she’ll ever be ready to confront her own demons? With danger around every corner, can Cath protect herself as well as the women whose safety is her paramount concern? Or has the potential for revenge already gone a step too far? Behind a Closed Door (Book 2, The Estate)Working on the notorious Mitchell Estate, housing officer, Josie Mellor, faces challenges every day, but not nearly as many as those of her tenants. Kelly Winterton is scared and alone after her partner has been jailed. Charlotte Hatfield has fled from her violent partner four times already. He’ll probably kill her if he finds her this time. Disowned by her family, someone is taking advantage of Amy Cartwright’s vulnerability. Who can she turn to for support? But Josie has her own problems to deal with too. As her home life deteriorates and she struggles to escape her controlling husband, she realises only a thin line separates her from the people she’s trying to help. When deadly violence erupts, will both she and her tenants become victims that no one will see? Fighting for Survival (Book 3, The Estate)When Caren Williams finds herself back on the estate she fought so hard to get away from, little does she realise she'll be living opposite her arch-enemy, Gina Bradley. Gina Bradley thinks she and her family rule Stanley Avenue so when Caren starts to become popular, she decides to hit her where it will hurt the most – she wants her husband. Lonely and depressed, Ruth Millington finds it a constant struggle to get through the dark times. Spiralling out of control, maybe she should let Gina's husband help her out when he comes calling. Brawling in the street, fighting on the square and conforming to peer pressure – it all comes down to holding your nerve. But this time not everyone will survive the notorious Stanley Avenue...

    She’s the girl that went astray. Can they find a place where they’ll both belong… together? Kylee Bauer’s high school classmates voted her most likely to succeed, not knowing that she would skip town with a bad boy, get hitched, and get pregnant—not necessarily in that order. Now she’s back and desperate for a second chance to get things right, all while ensuring her daughter makes better choices the first time around. Ron Kidd loved growing up in his small Virginia hometown so much that he never thought to leave it behind. Now he’s landed his dream role as principal of the same elementary school he attended as a boy. Some of the more seasoned staff, however, aren’t sure he’s up to the job and will do whatever it takes to make his days harder. When his old crush returns home as a single mom with a troubled kid in tow, Ron is sure he can help… even though he must swallow his feelings for Kylee to avoid losing his already shaky position as school principal. Unfortunately for him, this mini-matchmaker isn’t willing to give up on securing a happily ever after for her mom. Will Ron be willing to risk it all in the name of love? And what will Kylee do when her past comes calling? Will love be just out of reach? Find out in this fun, funny, and heartwarming tale of just how far one little girl will go to bring these two grown-ups together.

    Juggling the needs of her daddy-hungry son with her first love Ben and her estranged father, she’s fresh out of her klutzy charm to help her sort out the mess she’s created.Lying low at her granny's cottage in the small village of Ballydara, in County Galway, Aislin is faced with decisions about trust, forgiveness, and the true meaning of family. Can a commitment-shy young mother find lasting love?Books by Susan Colleen BrowneThe Village of Ballydara SeriesThe Secret Well, short story ebookA Christmas Visitor, short story ebook and the sequel of The Secret Well It Only Takes Once, A Village of Ballydara Novel, Book 1 (print and ebook)Mother Love, A Village of Ballydara Novel, Book 2 (ebook, coming soon in print)Children’s StoryMorgan Carey and the Curse of the Corpse Bride, a lighthearted Halloween story for middle-grade readers (ebook, coming soon in print!)Memoir Little Farm in the Foothills: A Boomer Couple’s Search for the Slow Life (print and ebook)

    Compelled to search for the lake in her dream and resolve the mystery, she’s aided by mysterious new friend Mark, who, oddly, keeps turning up wherever she happens to be.As the past increasingly haunts her present, she begins to wonder if the psychic gift that she’s always tried to ignore has anything to do with what’s happening to her.

    Not a good home, but at least there she can find food and shelter for her sisters, Lily and Tory.To the powerful Making Perfect corporation, however, the Slump is a gold mine, a source of unending test subjects. Once a month, squads of company officials invade the ruins to capture orphans for their facilities. What happens to the kids they take is unclear—none of them ever return.Then Summer herself is taken.Forced into a series of grueling experiments, she soon discovers that Making Perfect’s ultimate goal is far darker than anything she imagined. As she fights to get back to the Slump and her now-defenseless sisters, she begins to understand why once you enter Making Perfect, you never get out.

    She's the lone girl on the Ashton High wrestling team, grappling with opponents who refuse to compete against her, a few who want to crush her, and a coach who's less-than-pleased having a female in his practice room. At home, Mel's parents forbid her from seeing her new boyfriend, her grandmother insists she start preparing for her future by taking a dreary office internship, and her infuriating older brother, who's the varsity team captain, flirts with her best friend, Jade. Just when it seems things can't get any more complicated, an off-handed comment puts Mel at odds with her teammates, her brother, and, worst of all, her coach. But through a twist of tragedy and fate, Mel is given an unexpected opportunity to accomplish something no girl in her school's history has ever done--something that just may redeem her in the eyes of her detractors.

    Abandoned by his own mother, rejected by all but his loving father, Billy B is thrust into a silent hell alone, branded a freak and a misfit. Billy becomes the ultimate life spectator in a game of survival. Who can he count on to save him, when all seems lost?

    Her parents, Ben and Maggie, are devastated. So are their close friends Isobel and Eric.Isobel knows that her decision, taken years ago, not to have her own children vaccinated against measles is to blame for Iris’s deafness. And Ben knows this too. To make matters worse, Isobel is the woman he fell in love with in his twenties – the woman who married his best friend. As he and Maggie start legal proceedings, Isobel’s world begins to unravel.Lizzie Enfield’s compelling new novel explores the hearts and minds of ordinary people as they struggle to come to terms with the choices they’ve made. Acutely observed and utterly gripping, it explores love and loss, guilt and recovery, with humour, honesty and page-turning prose.

    A dead body in a blood spattered drawing room. A 6ft square container next to the body. 24 hours A padded cell. A single chair bolted to the floor. A woman bound hand and foot to the chair. DI Saul has just 24 hours to find out who the killer of the dead body is. 24 Hours to work out how the woman in the cell is linked with the murder. 24 hours in which at every turn, his own life seems to be inextricably linked with the events that unfold. 24 hours before the container in the room explodes.... Warning: Adult Content and Sexually Explicit Material.

    After a non-life threatening accident as a child, he hasn't quite developed like other boys his age. A group of older classmates take advantage of George's nature and force him into a situation that leads him to discover some interesting things about himself.