hi guys,
i'm a teacher.i am working out on a pupil's marksheet.the problem is ,it appears hastags error like this ####.please help.(in yellow cell)
hi guys,
i'm a teacher.i am working out on a pupil's marksheet.the problem is ,it appears hastags error like this ####.please help.(in yellow cell)
Try making the column wider.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
i had tried.nothing happens
i wanna to show the pupils rank.(in yellow cell)
Can you point a sample workbook?
a zip file was uploaded in my first post.check it out!
anyone would help me?
Please provide an Excel file (NOT a ZIP file). Thanks.
PS You need to exercise some patience!!!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Also, tell us which sheet (and column) the problem occurs on.
Pete
On the SKA sheet, change the formula in BD6 to this:
=IF(B6=0,"",SUM(BC6,AV6))
then fill it down the column. That will get rid of the #VALUE errors.
Rory
If Rory's recommendation doesn't do it for you, I am unable to make any changes to your file so if you could upload a file that we can work with, that would be better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks