Forum Discussion
Excel formula to identify unreturned uniform
Dear community I work in a school and through attempting to get more processes digitised, I am adapting my spreadsheet for passes from school and borrowed uniform. Sometimes students forget to re...
Hi Sergei
Yes there won't be any unique values, and some students may appear more than once on the borrowed uniform list. I need something to identify if there are any items that the student has not returned. I can't specify a date to look up as I won't know the date that the issue will be from.
The information provided in the sample file is all the relevant information. Nothing else matters regarding identifying an issue.
Yes there won't be any unique values, and some students may appear more than once on the borrowed uniform list. I need something to identify if there are any items that the student has not returned. I can't specify a date to look up as I won't know the date that the issue will be from.
The information provided in the sample file is all the relevant information. Nothing else matters regarding identifying an issue.
You better know business logic, but without such identification you can't link data in both tables. More exactly you can, but in some cases result will be incorrect.