(10-03-2023, 08:50 PM)Bouki Wrote: (10-03-2023, 06:38 PM)HoosierShave Wrote: (10-01-2023, 08:26 PM)Bouki Wrote: Felce Aromatica (Saponificio Varesino) easy green
I’ve rigged my spreadsheet to choose a soap for me each day at random.
Very interesting and intriguing concept! As a fellow wet shaving/Excel enthusiast, which function are you using and how did you set it up to do it daily? Or are you just entering a new random function each day?
This is the code for the randomizer: VLOOKUP(RANDBETWEEN(1,COUNTIF(Soaps::B,"H")),Soaps::A: D,4).
Thanks
Bouki, that's a great code! I've been using Tables alot more in Excel over the past couple years but still haven't converted my 5-year old Wet-shaving spreadsheet. Maybe when things slow down I'll take some time to create a new one.