Log In
Register
Home
New Member
September 8, 2020
Offline
Hello Everyone:
I am creating a spreadsheet of video coursework that I want to take to endeavor to become more proficient at web developing. I have attached the Excel spreadsheet that shows where I am at thus far.
I am using Excel for Mac 365 version 16.40.
Where I show that there are, for example, 11 courses in a course path/certificate, instead of just showing the COURSE NUMBER in the COLUMN, I would like to show:
1/11
Or
1:11
Or
1 out of 11 in an individual CELL.
To indicate in only one CELL that there are 11 courses in the path/certificate and each course is numbered X out of 11, as in the “Become a Web Designer” PATH/certificate. Presumably, this is something that I might be able to sort on if needed?
As you can see from the text at the bottom of the attached sheet, I tried experimenting with various ways of listing the COURSE/TOTAL COURSES, but without any success.
Can someone please tell me your thoughts on this and if you think that there is a possible way to display the COURSES listed as 1 / 11, 2:5, or 3 out of 3 or 3 | 13? Is there a way to achieve this without great effort?
Please let me know if I don’t make sense and I will happily clarify. Thank you for any help that you can offer.
Best wishes,
~Antonio
See Answer
Trusted Members
December 20, 2019
Offline
Is this what you are after?
=IF(C2="","",C2&"/"&MAXIFS(C:C,F:F,F2))
Answers Post
New Member
September 8, 2020
Offline
Hello Purfleet,
OMG!!! That is EXACTLY what I needed. You must be a GENIUS to be able to write a Formula like that. Not only that, but you also understood what I was trying to describe. Bravo!!!
I am humbled by your generosity and I thank you very much for your help! You made my day year!!!
Thanks again,
~Antonio 
1 Guest(s)
