u/thowel01

Hi all,

This is a followup to my previous post; thank you for the incredibly helpful comments on that post. I went with using the checkbox and am giving up on the visual marker/dice idea. I did see on another post that it may be possible to write a statement within that excludes values from being generated that have a strikethrough or are a different color. Is this possible to do outside of Apps Script?

Here's a screenshot of what I'm working on.

1. I want to randomly generate a title from column A by clicking the checkbox in R1. The corresponding # will tell me which title is chosen.
2. This is manga so the same title is often duplicated in several rows depending on how many books are in the series.
3. For example, if I roll # 241 "Devils' Line", I also want to remove numbers 233-243 from consideration for all future rolls.
4. The current formula in Q2 says =randbetween(4,1254)

Question: Is it possible to add an if statement/something similar to the randbetween statement (not in Apps Script) that will account for a strikethrough or some other marker? I don't want to have to delete the titles that have already been chosen but I no longer want them as choices for the randbetween formula moving forward.

Hope this makes sense.

https://preview.redd.it/sfjbukcfznah1.jpg?width=2070&format=pjpg&auto=webp&s=61ab79ce5c2ace6fab41d448f3dcc1d174c1f64b

I have a spreadsheet with 1,200 rows of data, and I want to randomly be able to pick one of these rows to look at at any given time. I’d also like an interesting way to show my audience when this random row is being generated. I’ve tried =randbetween but I keep having to refresh the page to get the number to update and it’s not as interesting to look at. I’d love to be able to click on a button instead and have the number refresh more instantaneously.

This may be more geared towards using VBA which I unfortunately don’t know anything about but any simple solutions would be appreciated.

I’m trying to figure out how to count blank cells in column H, but only if there is info in column A.

Right now, I’m using =countblank(H4:H145), but I don’t want to keep manually updating H145–>H146–>H147… etc as I add in new lines of data. If I just use =countblank(H4:H), it counts blanks outside of my table.

Any suggestions?

I previously posted that on Tuesday my Gyro DX order was cancelled due to a “system error” by GSCUS. I was offered no remedy other than that I could buy it once it came in stock online.

I got a follow up email about 23 hours later saying they actually could reinstate the preorder as long as I paid the correct price. I now have 24 hours to make the purchase with the link they sent.

I did cancel 5 other preorders that night for additional context including Popup Coco, Sakura Sparkle, and 3 other ones since I was disappointed in the situation.

I want the bear bonus but I don’t think I want to bother anymore. I have a preorder with AmiAmi now; GSCUS comes out to $80.63. I wish I remembered what I was quoted the first time around 😞.

Thanks for following along.

TL;DR: If you own—or are interested in owning—merchandise based on Japanese media (anime, manga, video games, etc.), I'd appreciate your participation in this survey!

Hi all!

I've been a member of this community for awhile, and I recently created a survey to better understand how people research, shop for, and collect merchandise based on Japanese media.

I've personally been collecting figures online for the past 2.5 years through online retailers such as AmiAmi, USA Gundam Store, Solaris Japan, and Good Smile Company US. Through this survey, I'm hoping to learn how our collective experiences compare with one another.

The survey takes less than 10 minutes to complete, and once I've gathered enough responses, I'll share a summary of the results. Hopefully, I'll have enough responses in the next 4 weeks.

If you know anyone who currently collects—or is interested in collecting—Japanese figures or other related merchandise, please feel free to share the survey with them as well.

Thank you for your time and participation. Feel free to reply if you have any questions.

TH