1 min readfrom 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

submitted by /u/Duhfishman47
[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
#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