Prodigits |
! You are not logged in to Prodigits. Please register or login.
* M-S-EXCEL > Topics

* New Topic
miirfan June 2016
By-Pass Password (0)
Use vba for worksheet and software for encrypted file[link]fb:https://m.facebook.com/groups/500526343449980?view=permalink&id=599718343530779&refid=18
miirfan February 2016
A-z without dragging (0)
A-z without dragging =CHAR(64+COLUMN(A1)) or use this one =CHAR(65+ROW(A1)+COLUMN()-2)
miirfan February 2016
Rank for passing (0)
Rank for passing =If(minimum (a2:c2)35,''-'',average (a2:c2)
miirfan February 2016
Get only first digit integer (0)
Get only first digit integer =1+MOD(A1-1,9)
miirfan February 2016
miirfan February 2016
Get Characters & no's in diff cells (0)
Get uae and no's in diff cells UAE1111111111 =RIGHT(A1,LEN(A1)-FIND(''UAE'',A1)-2)
miirfan February 2016
Keyboard Shortcuts (0)
shift+f3 for case Ctrl+K Insert Hyperlink Ctrl +1 Format dialog box Ctrl +2 bold Ctrl +3 Italic Ctrl +4 Underline Ct

topics posts

fav Bookmarks
* M-S-EXCEL

Awesome Wallpapers

Download PRODIGITS Android APP