▓ Microsoft Excel سوالات، مشكلات و مباحث در اینجا ▓

[worldm]

سلام وقت بخیر
دوستان فایل اکسلی دارم که میخوام تاریخ میلادی رو فارسی کنم ولی فرمول شو نمیدونم چطوری تغییر بدم

روی سال که کلیک میکنم فرمول =IFERROR(YEAR(TODAY())+N6,"") رو نمایش میده و به ترتیب سال میره بالا

میخوام شمسی باشه و از 1400 شروع بشه و بره بالا
ممنون میشم فرمولشو بگین

- - - Updated - - -

[gheysar.]

سلام
قطعاتی هستن که شماره فنی دارن و میخوام توی اکسل مثلا 700 قلم کالا که هرکدوم شماره فنی خاصی دارن رو با اسمشون عین یه دفترچه یادداشت ، یادداشت کنم . همچنین میخوام اگر کد تکراری وارد کردم متوجه بشم.
ویدیویی خاصی هست که به من کمک کنه ؟
من ویدیویی پیدا نکردم
ممنون.

[enimonte]

سلام
قطعاتی هستن که شماره فنی دارن و میخوام توی اکسل مثلا 700 قلم کالا که هرکدوم شماره فنی خاصی دارن رو با اسمشون عین یه دفترچه یادداشت ، یادداشت کنم . همچنین میخوام اگر کد تکراری وارد کردم متوجه بشم.
ویدیویی خاصی هست که به من کمک کنه ؟
من ویدیویی پیدا نکردم
ممنون.

میتونی از تب دیتا و data validation رنج مشخص کنی که اگر داده تکراری وارد کردی اجازه ثبت بهت نده

اما راحت ترین کار از تب home-conditional formating--highlight cell rulles- duplicatevalues رنح مشخص کنی که اگر داده ای تکراری بود برات هایلایت کنه

- - - Updated - - -

سلام
قطعاتی هستن که شماره فنی دارن و میخوام توی اکسل مثلا 700 قلم کالا که هرکدوم شماره فنی خاصی دارن رو با اسمشون عین یه دفترچه یادداشت ، یادداشت کنم . همچنین میخوام اگر کد تکراری وارد کردم متوجه بشم.
ویدیویی خاصی هست که به من کمک کنه ؟
من ویدیویی پیدا نکردم
ممنون.

میتونی از تب دیتا و data validation رنج مشخص کنی که اگر داده تکراری وارد کردی اجازه ثبت بهت نده

اما راحت ترین کار از تب home-conditional formating--highlight cell rulles- duplicatevalues رنح مشخص کنی که اگر داده ای تکراری بود برات هایلایت کنه

[Myramillan]

The Roman club has long and rich tradition of being among Italy's most prestigious footballers. Despite their impressive reputation, they've not been able to claim any significant international as well as European title since. The situation has improved since Jose Mourinho's arrival in 2021 along with AS Roma's victory in the UEFA Conference League cup run that culminated in their final victory in the month of May 2022.


But, FC 24 stars will take over the club prior to anything happens and that means they'll need to complete an old-fashioned squad overhaul and bring promising young players to the forefront (the young forward the Nicola Zalewski, comes to mind) and then make clever moves on the market for transfers in the early stages of their career.


The problem of being the new owner of AS Roma lies mainly in the need to implement several radical changes to the team immediately. Although there is certainly potential talent within the squad however, it's not enough to compete for top honours in the very first season, which makes the journey towards Serie A and Champions League glory a bumpy and long one.


For those who haven't yet played the managerial mode of FIFA or haven't returned to it in the past It is highly recommended that they select the team with a huge transfer budget and a highly-regarded team for the start. This will allow them to ease into the rigors and challenges of managing the football team as well as get acquainted to the format and goals that are part of FC 24's new Career Mode.


Manchester United is one of the most successful teams to oversee as the Career Mode rookie. After a successful period of transfers, the team will head into the 2022/22 Premier League season strengthened by the presence of Raphael Varane, Jadon Sancho as well as Cristiano Ronaldo. In addition to the wealth of top talent currently in their squad, they will be able to compete for the top honors right from the beginning and without having to invest a penny on the addition of any footballers.Management of Manchester United is childishly easy. Paris Saint-Germain is a team that manages itself. Their front threemade up comprising Lionel Messi, Neymar Jr and Kylian Mbappe, is a blatant example of the reason the UEFA's Financial Fair Play regulations don't actually apply to the wealthiest clubs on earth. The front three is enough to continue to win Ligue 1 titles and the Champions League for many consecutive years.
Best place to buy FC 24 Coins or FUT 24 Coins on MMOexp.com.

- - - Updated - - -



The Roman club has long and rich tradition of being among Italy's most prestigious footballers. Despite their impressive reputation, they've not been able to claim any significant international as well as European title since. The situation has improved since Jose Mourinho's arrival in 2021 along with AS Roma's victory in the UEFA Conference League cup run that culminated in their final victory in the month of May 2022.


But, FC 24 stars will take over the club prior to anything happens and that means they'll need to complete an old-fashioned squad overhaul and bring promising young players to the forefront (the young forward the Nicola Zalewski, comes to mind) and then make clever moves on the market for transfers in the early stages of their career.


The problem of being the new owner of AS Roma lies mainly in the need to implement several radical changes to the team immediately. Although there is certainly potential talent within the squad however, it's not enough to compete for top honours in the very first season, which makes the journey towards Serie A and Champions League glory a bumpy and long one.


For those who haven't yet played the managerial mode of FIFA or haven't returned to it in the past It is highly recommended that they select the team with a huge transfer budget and a highly-regarded team for the start. This will allow them to ease into the rigors and challenges of managing the football team as well as get acquainted to the format and goals that are part of FC 24's new Career Mode.


Manchester United is one of the most successful teams to oversee as the Career Mode rookie. After a successful period of transfers, the team will head into the 2022/22 Premier League season strengthened by the presence of Raphael Varane, Jadon Sancho as well as Cristiano Ronaldo. In addition to the wealth of top talent currently in their squad, they will be able to compete for the top honors right from the beginning and without having to invest a penny on the addition of any footballers.Management of Manchester United is childishly easy. Paris Saint-Germain is a team that manages itself. Their front threemade up comprising Lionel Messi, Neymar Jr and Kylian Mbappe, is a blatant example of the reason the UEFA's Financial Fair Play regulations don't actually apply to the wealthiest clubs on earth. The front three is enough to continue to win Ligue 1 titles and the Champions League for many consecutive years.
Best place to buy FC 24 Coins or FUT 24 Coins on MMOexp.com.