1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

how to define a name for specific word in a column, that also expands whenever I add more?

So, I have a column called element name and defined a "element.name", and under it there Water, Fire, Earth and Air. Can I select "Element Name" column and define a name but only for entries with word "Fire"? also I need something dynamic, whenever I add any entry with "fire" it'd also add it automatically to the name definition.

hopefully I explained this well lol. Also I preferred to use Avatar as a reference instead my real company for idk why :D

submitted by /u/nanoosx
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#Fire
#element name
#define a name
#dynamic
#definition
#automatically
#Water
#select
#column
#entries
#Earth