2024-03-24 22:55:16
الحمدلله و الشكر لله دي قائمة بكل المعادلات الي عملتها في #الاكسل حتى الآن بفضل ربنا
كل المعادلات دي مبنية على معادلة LAMBDA ماعدا معادلة ADDNOTE فهي تعتمد على ال Visual Basic
" #Hazem_Hassan : Custom Excel Functions List "
FILLDATA
Multi-directional Fill of Empty Cells in Excel
= FILLDATA ( Range , Direction , Errors , Avoid )
https://www.linkedin.com/posts/hazemhassandrexcel_excel-lambda-n-activity-7160169452746031104-wrb2?utm_source=share&utm_medium=member_desktop
TEXT.SELECT
Extract Anything You Want from a Cell
=TEXT.SELECT ( MixedText , Select , Space , Keep)
https://www.linkedin.com/posts/hazemhassandrexcel_excel-hazemabrhassan-drabrexcel-activity-7154720621262778368-AgOM?utm_source=share&utm_medium=member_desktop
ADDNOTE
Add professional, dynamic notes to your cells with ease
=ADDNOTE (Range,Commentor, Comment,Criteria)
https://www.linkedin.com/posts/hazemhassandrexcel_excel-excel-visualbasic-activity-7155479235736854529-STWN?utm_source=share&utm_medium=member_desktop
PROUNIQUE
The Enhanced UNIQUE Formula: More Than Just Unique
= PROUNIQUE ( Range , CaseSensitivity , RC )
https://www.linkedin.com/posts/hazemhassandrexcel_excel-hazemabrhassan-drabrexcel-activity-7157295034118070272-4VQG?utm_source=share&utm_medium=member_desktop
UNPIVOT
Simply , UNPIVOT your data
= UNPIVOT ( Range , Cols , Blank_Options , Header )
https://www.linkedin.com/posts/hazemhassandrexcel_unpivot-hazemabrhassan-drabrexcel-activity-7158368034926010368-KoT3?utm_source=share&utm_medium=member_desktop
XREMOVE
Wipe away anything you want from a cell in any direction.
= XREMOVE( Range , Xtxt , Xdirection , CaseSensitivity )
https://www.linkedin.com/posts/hazemhassandrexcel_excel-lambda-hazemabrhassan-activity-7163785228405071872-c0JN?utm_source=share&utm_medium=member_desktop
ISCONTENT
Distinguish between Real Data vs. Non real Data (Null)
=ISCONTENT(Range)
https://www.linkedin.com/posts/hazemhassandrexcel_excel-lambda-exampleabr1-activity-7165966671084470273-mkM0?utm_source=share&utm_medium=member_desktop
CLEARDUPES
The function simply removes consecutive duplicate values.
=CLEARDUPES(Range, SkipCol)
https://www.linkedin.com/posts/hazemhassandrexcel_cleardupes-excel-lambda-activity-7177018151048527872-yv8M?utm_source=share&utm_medium=member_desktop
FSCQTR
Determine the QTR in excel with the possibility of changing the month of the beginning of the year
=FSCQTR ( Range , Start_Month )
https://www.linkedin.com/posts/hazemhassandrexcel_qtr-excel-fscqtr-activity-7177590196262105089-ug-J?utm_source=share&utm_medium=member_desktop
#Hazem_Hassan #Dr_Excel #Hazem_Hassan_MVP
5.9K views19:55