•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How would I convert a table of descriptive text to a numeric formula?
I have the following dataset as an example. It lists names and absences - how can I convert it to record a total number of absences if 1 full day absence = 1, and a part day absence =0.5 to determine a total? Thank you
| Name | 2 full day absences, 2 part day absences |
|---|---|
| Name 2 | 0 full day absences, 3 part day absences |
| Name 3 | 2 full day absences, 0 part day absences |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#large dataset processing
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#formula generator
#absences
#dataset
#absence calculation
#total number of absences
#full day absence
#part day absence
#numeric formula
#descriptive text
#conversion
#record
#data management
#Excel
#name