Forum Discussion
How do I identify the next personal who needs to do a task in excel?
Hey y'all, Please reference the picture below! I have this Excel where people will be filling in a completed task and I need to identify the next person to do the task. I had a few ways that I th...
I just tried it but it came up with #NAME?
I noticed that you mentioned doing this on Office 365 or Excel for the web. I am working off of Excel 2016 on the desktop application. I don't know if that has anything to do with it not working? Is there a way to make this work on that version of Excel?
Thank you for your help!
Yes that's because e.g. LAMBDA isn't available in Excel 2016. Alternatively i'd create a helper column with this formula.
=ISNUMBER(D2)+ISTEXT(E2)Then i'd apply a custom sort by column F (helper column) in ascending order ("aufsteigend" in german in the screenshot).