Forum Discussion
Excel Formula for database
May_ThuThu_Aung, it is a bit confusing but I think you will find the answer in the links that I will provide below. Please let me know if that solved your problem. If you still need help after that, please answer back sending a sample file and I'll try to help further.
video: https://www.youtube.com/watch?v=VxReJslyJm8 (see more information on the video description.)
Playlist with other examples: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y
I amended the file and all seems to be working now. You just need to complete a table with the table codes as explained in the tutorial attached.
I used a simpler formula for the names and the data validation.
I hope this helps! Good luck and let me know how it goes.
Hi Celia_Alves
Please accept my apology for the delayed reply because I was on-duty traveling start from this week until today. I've looked at the files of tutorial and database which you sent, they are very helpful for my database and I've learned new formula from you. And then, I completed the table as you explained, now I'm working on this but not yet found the error. I'll take time to fill the data if it is ok I'll start using for the entry process.
May I ask you one thing, how did you do this formula. I've tried this but not yet succeed.
Thank you very much again for your help Celia_Alves . Have a nice day.
- @May_Thu Thu-Aung
Hello! I am glad that you made progress.
Please feel free to use that file that I sent you for your work if that helps you.
That formula is the way Excel writes formulas when we are working inside tables. The square brackets and @ sign are put by Excel when we refer to a cell in another column of the table and in the same row where we are righting the formula.
Tables is one of the most important things one should know in Excel.
I recommend this video about Excel Tables.
Starting on minute 10:35 it explains a bit about formulas in tables, but I recommend watching the entire video if you are not familiarized with tables.
https://youtu.be/Qk7bChbIefg
If you use an older version of Excel, you may get in your formula "[This row]" instead of "@". The following video explains this and a few note very useful things that we should know about using tables and formulas inside of it:
https://youtu.be/tTYQrk3hSYo
I hope this helps! Good luck!Hello! Celia_Alves all the videos and knowledge that you shared were very useful. Thank you so much. I'll share it with my colleagues for learning development. They let me pass their big thanks to you. Have a nice weekend. See you later. 😄
- I am glad that I could help and happy to see your commitment to keep learning and share knowledge with your colleagues. That's the best way to go.
All the best.