•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?
Our take
Transforming descriptive absence data into a numeric formula is a straightforward process that can enhance your data analysis. In your dataset, each full day absence is valued at 1, while a part day absence counts as 0.5. By applying this logic, you can easily calculate the total number of absences for each individual. For instance, if a person has 2 full day absences and 2 part day absences, their total would be 2 + (2 * 0.5) = 3.
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]
Read on the original site
Open the publisher's page for the full experience
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