Search results

  1. S

    Scientists rename human genes to stop Microsoft Excel from misreading them as dates

    It is extremely frustrating and even dangerous when people use the wrong tool for the job.
  2. S

    The businesses that will likely close for good after the looting in South Africa

    So much commendable restraint that they didn't even bother showing up?
  3. S

    Please do a MyBroadband speed test on Rain

    5G Premium Cape Town CBD, about 250m from the tower Ping: 19ms Download: 449.08Mbps Upload: 59.44Mbps
  4. S

    Rain 5G Winter Promo

    Please keep us posted on how smoothly their current Rica process works for you. I'm tempted to order, but the Rain Online RICA thread is making me a bit hesitant...
  5. S

    MS Excel - Help with Formula

    Alternatively, as Messugga said, PivotTables were made for this, and they're an amazingly useful tool to figure out if you work with Excel a lot. Four easy steps: Click on one of the cells with data on your sheet Insert tab on the top of your screen, then PivotTable button (usually the first...
  6. S

    MS Excel - Help with Formula

    If Store is in Column A, and Product is in Column B, and Quantity is in Column C, then the formula: =SUMIFS(C:C, B:B, B2, A:A, A2) where 2 is the row that you're entering the formula into. i.e. if the first entry starts on row 3 or 4, use that instead of 2.
  7. S

    I replaced my old Microsoft keyboard with a new Apple model

    IMHO, if you're going to be using a keyboard for 8+ hours a workday for the next few decades, you owe it to yourself to invest in a decent one that isn't going to end up giving you carpal tunnel or RSI five years down the line from now. I bought a MS Ergo 400 four years ago for R600 and it's...
  8. S

    Apogee is back

    There's a HD remake on Steam if you're interested in giving it another shot:
  9. S

    Criminals find a way around electric fences

    So the moral of the story is to turn the river into a moat and fill it with crocodiles?
  10. S

    Any recent Amazon experiences

    Ordered something from Amazon US on Monday, arrived today. AmazonGlobal Priority Shipping.
  11. S

    FSCA issues warning to South Africans about Bitcoin investments

    As opposed to investing in local industry? :unsure:
  12. S

    Microsoft’s Power Automate Desktop is now free for all Windows 10 users

    Oh wow, didn't see that coming. We use the cloud version of Power Automate quite a bit at work. Will be interesting to see what we can use this for...
  13. S

    InStr function

    Yep, works fine on my side. Access 2016. Double check that the brackets line up in your formula, you might have missed a closing bracket
  14. S

    InStr function

    TestInstr: Left([ProductID], InStr([ProductID], "/") - 1)
  15. S

    InStr function

    What is the name of the field you're using InStr on? IIRC, Access is really finicky about punctuation and other non-alphanumeric characters.
  16. S

    Excel formula amendment - tiny change :)

    If your version of Excel has =SORTBY, you can sort the red range in-formula using something like SORTBY($D$1:$E$10, $D$1:$D$10) or even better put it in a table and have nicer syntax like SORTBY(Red, Red[Num]) Then again, if you have access to SORTBY, you probably have access to XLOOKUP...
  17. S

    Excel formula amendment - tiny change :)

    Using =IF or =IFS is okay if you're only dealing with 3 or 4 cases, but it's going to become a real schlep to scale up to more cases. =VLOOKUP(B1, Table1, 1, TRUE) or =LOOKUP(B1, Table1[Qty], Table1[Price]) with an =IFERROR around it (or 0 > x >= 500 validation on B1) looks a bit cleaner to me...
  18. S

    Eskom implements stage 3 load-shedding

    Have they considered another emergency backup system for when their current emergency backup system is not working? :unsure:
  19. S

    Hardware Bargains - Open Thine Wallet

    SSD all the way. I would rather use a 10 year old laptop with an SSD, than a 2021-model laptop with a HDD.