@@CorporateGuy shashank how about to develop excel based security daily situation report dashboard... actually i already did but i like you to develop the same such kind
@@CorporateGuy 1. Daily deployment 2. Visitors 3. Contract manpower 4. Material movement with previous day balance 5. Material receipt 6. OGP movement 7. Commute vehicles movement 8. SAS footfall 9. Security incident trends 10. Miscs
Thank you this is very helpful. I'd like to ask, what if we use the risk ID and title for the sentence in the risk matrix? Do we re-use the textjoin formula to combine them?
I think you can't use it in below 2019 but if know little bit of VBA,,,I think this article might help you stackoverflow.com/questions/45843881/textjoin-udf-for-excel-2013 Otherwise I will find another alternative
Excellent..Shashank...I am becoming your fan now...
Thank you so much sir,,,it great to have you in my professional network...
Great. Very usefull information shared.
Thank you ☺️
good job
Excellent!
Thank you ☺️
Good going Shashank...
Thank you sir 😊
@@CorporateGuy shashank how about to develop excel based security daily situation report dashboard... actually i already did but i like you to develop the same such kind
Sure no problem we will do that,,let me know what do you want to include in that report
@@CorporateGuy
1. Daily deployment
2. Visitors
3. Contract manpower
4. Material movement with previous day balance
5. Material receipt
6. OGP movement
7. Commute vehicles movement
8. SAS footfall
9. Security incident trends
10. Miscs
Okay got it 👍
Great, i loved this.
Keep it up👍👍
Thank you this is very helpful. I'd like to ask, what if we use the risk ID and title for the sentence in the risk matrix? Do we re-use the textjoin formula to combine them?
Good
Pls provide a solution for this on excel 2007
Many thanks
Dont know abt VBA
My excel cannot pick up the risk table when applying the textjoin formulae for impact and probabilty
You neee to make sure that you are using the latest version
Please share the xls file link
Thanks. Can we use same formula in lower version of excel ? If No please suggest alternate solution.
I think you can't use it in below 2019 but if know little bit of VBA,,,I think this article might help you
stackoverflow.com/questions/45843881/textjoin-udf-for-excel-2013
Otherwise I will find another alternative
There is no download file in description
Will share, thanks for infor
@@CorporateGuy Dont see file in the description to download
Hi, I am really sorry I have lost that file. I will try to find it and upload the link.