•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do you get a percentage from text within a cell range?
I have a sheet that has random dates within cells c1:c60. Some cells have a date (example 05/15/2026) whereas others are completely blank.
I need a formula that will automatically update a percentage of how many cells have “data” within the cell vs. those that do not.
Example, if I had 50 dates within these 60 total cells, the percentage TOTAL at the bottom should say “83.3%”. Once I add an additional date within these cells, it should now reflect “85%”. So on and so forth.
I don’t need it to read the date at all. Just if these “something” within the cell it recognizes it as “done”.
Hope I made sense. Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#percentage
#cells
#data
#formula