J
Justin
I'm trying to modify a spreadsheet with a number of automatic functions and I
am sadly lacking proficiency with excel.
1. I want to create five columns (B-F) with different drop down lists of text
2. I would like each text in the drop down lists to equal a number value,
i.e. 1-7
3. I then want the "A" column to find the sum of columns "B-F"
4. Finally, I would like the rows to automatically sort based on the value
in column A
I'm not sure how well I explained that, but I would greatly appreciate it if
anyone could lend me a hand.
am sadly lacking proficiency with excel.
1. I want to create five columns (B-F) with different drop down lists of text
2. I would like each text in the drop down lists to equal a number value,
i.e. 1-7
3. I then want the "A" column to find the sum of columns "B-F"
4. Finally, I would like the rows to automatically sort based on the value
in column A
I'm not sure how well I explained that, but I would greatly appreciate it if
anyone could lend me a hand.