Search results

  1. 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...
  2. 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
  3. S

    InStr function

    TestInstr: Left([ProductID], InStr([ProductID], "/") - 1)
  4. 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.
  5. 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...
  6. 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...
  7. 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:
  8. 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.
  9. S

    How South Africans will register for a COVID-19 vaccine

    You people are overcomplicated things, man. Email every citizen a copy of "Copy of Copy of Electronic Vaccine Data System (9) (Final) (Final Final) (autosave).xlsx" Each person then adds a row to the end and fills in their details in their preferred format They then email it back An unpaid...
  10. S

    Epic tech deals this week

    I too miss people fighting over who gets to post a link to Guzzle first.
  11. S

    Sheets / Excel question re. percentages

    Formula in F3: =B3/A3*E3
  12. S

    Great tech deals this week

    Was R545 last month :(
  13. S

    Star Wars vs Star Trek

    Star Wars is just a cheap ripoff of Space Balls, and Star Trek is merely a poor imitation of Galaxy Quest.
  14. S

    Hardware Bargains - Open Thine Wallet Asus VG249Q TUF Gaming 23.8" Full HD (1920x1080) 144Hz 1ms IPS FreeSync Gaming Desktop Monitor for R3999 Cheapest 23.8"...
  15. S

    Budget Gaming Monitor (R4k)

    That Samsung is R3799 at Woot, and the LG is R3599. Don't forget to take into account that lots of the online shops need to charge extra shipping for monitors.
  16. S

    Calling All Elite Dangerous Players in South Africa

    Rain 4G worked great for me in Elite, granted this was about 1~2 years ago since I last played, and I'm one of the few people on here who haven't ever had serious issues with throughput or latency via them.
  17. S

    The latest Black Friday tech deals in South Africa

    Why is Incredible Connection still selling laptops in 2020 without SSD/eMMC boot drives? That should be illegal under crimes against humanity.
  18. S

    Hardware Bargains - Open Thine Wallet

    What's the normal going price for 144Hz monitors these days? I don't want to get taken for a ride next week. I'm guessing about R6500+ for 1440p, and R4500+ for 1080p IPS?