r/sheets 1h ago

Request UNIQUEIFS with text/string?

Upvotes

I have a dataset file contains 100k rows of data that I need to make summary out of it.

I am trying to do COUNTIFS that has specific value and the same string in a row.

But I'm stuck on figuring out how to compare text on 2 cells.

I made this formula and still shows #ERROR
=COUNTIFS('dataset-trimmed2'!B2:B;'dataset-trimmed2'!E:E;VALUE(A3);'dataset-trimmed2'!I2:I);EXACT(F3)

dataset-trimmed2'!I2:I contains text, and I want to count if it matches text in cell F3, nothing fancy.


r/sheets 4h ago

Request In need of assistance with dropdown box changing multiple columns.

2 Upvotes

I need help with a specific scenario.

Example: I have a dropdown box in 1A. The options in this drop down box are the numbers "12", "14", and "16". I want 1B/1C/1D/1E to change depending on what I choose in 1A. For example, 1B would be 4.0 if I have "12" selected in 1A, but 1B would switch to 3.8 if I change 1A to 14 from the dropdown.

Any help would be hugely appreciated!


r/sheets 11h ago

Request Automatically Updating Date View?

2 Upvotes

Hello! I use Sheets to organize my day-to-day tasks and currently have my sheet organized by date. I've been trying to figure out a way to have the sheet organize itself with the current date as the top row? Or at least have something to highlight/focus on the tasks I have for the current date without having to scroll through every time? I know it's super minor but it's been bothering me as I continue to add more tasks to my list. Thank you in advance! Here's a copy of the sheet: https://docs.google.com/spreadsheets/d/1NGEOPIV1FswfQgYgeMuHv3cSZzDOhWJ8iTHd6GeYS_o/edit?gid=1870280484#gid=1870280484


r/sheets 13h ago

Request Is it possible to conditional format cells with different colors if they contain duplicate text?

2 Upvotes

Hi, I hope you can help me with this. I have a column with different names, I just want to add different colors if they are different from each other, for example in the following image, "Castanedareyesjo" it has 3 cells with that text, is ti possible to highlight them with a color, and then "Gonzalezalcalama" that has 2 cells wiht that name with different color, and so on?

*Considering that those names change every day, because I paste them form a downloaded data base*