#named ranges

[rattusreckless]

named ranges in google sheets

TIL that you can name references to cells or ranges in googlesheets to make human-readable code. cant believe i never knew about this til now so i'm making a thing.

This is the hidden motherfucker: the name box

If you expand it, you'll see named ranges... which includes: sheet names and table names.

But you can create your own custom named ranges by clickin manage named ranges in the name box menu.

This will pop up on the far right:

Now you can put it into use:

So:

[emptymanuscript]

For the record, this formula:

=if(isblank($A2),FALSE(),$A2=if(ifna(match(indirect(address(row(),column($A$1),4)),indirect("PriorT"),0),-1)>1,indirect(address(row(),column($A$1),4)),FALSE()))

to make sure that an entire row in a Google Sheet would highlight based on whether or not a cell in the first column, the name of the movie, matched ANY cell in another column, a list of names of movies watched,

took me far far too long to figure out today for the value of what I was doing.

AND I suspect there is a much better way to do it, which just annoys me more. Somewhere, someone has made an illustrated guide to doing this that takes 30 seconds to read. I just couldn’t find it.

It took me a good hour at least to find someone saying you had to put named ranges inside quotes inside an indirect function for conditional formatting when you don’t have to do that inside a standard formulae.

:p

I kind of hate the way you input conditional formatting just a little, to be honest. Like, they really couldn’t figure out a way to preview how things are working???

:p

[ngcittraining-blog]

Excel - Named Ranges - Using names instead of ranges

[strugglin2xl]

Format Tables in Excel using VBA - #Excel #VBA

Format Tables in Excel using VBA – #Excel #VBA

Excel Tables make analyzing data, a breeze. It surprises me that it is not used as often as it should. It automatically “includes” new data you add to your spreadsheets, it automatically drags down formulas for you, it automatically formats the tables for you. In addition to that, you can use structured references that make your formulas tractable without having to name each range. You can also l…

View On WordPress