Profile

Cover photo
Rahim Zulfiqar Ali
Attends ICAP
Lives in Karachi
407 followers|248,252 views
AboutPostsPhotosYouTube

Stream

Rahim Zulfiqar Ali

Shared publicly  - 
 
 
A tech forecast of mine from 20 years ago is coming true today at MIT… a needle table that responds to the user’s motions and emulates him/her in moving objects around.  We aren’t yet at the exercise floor I portrayed in “NatuLife.” But clearly it is coming.

 http://www.fastcodesign.com/3021522/innovation-by-design/mit-invents-a-shapeshifting-display-you-can-reach-through-and-touch
The Tangible Media Group at MIT's Media Lab has unveiled a futuristic display made of atoms, not pixels.
1
Add a comment...

Rahim Zulfiqar Ali

Shared publicly  - 
 
 
+Rahim Zulfiqar Ali of #Excel  Basement shows how to sum every other row using the MOD function.  Useful tip is you have unclean data.
http://youtu.be/Z3SzkDgYi5M
1
Add a comment...
 
"Locking Cell depending on other cell value" (To be applied on many rows)
e.g. 1 in Cash Book sheet, until date (B11) is written no subsequent cells in row are not available (C11 and onwards) i.e. locked. 
e.g. 2 if nature of receipt is mentioned (F11) then amount column of receipt is available (H11) and not payment amount column (I11).

Any possible solution via VBA ? or other excel feature !!!
2
1
Sumit Bansal's profile photoHessel de Walle's profile photoGerry Roybal's profile photoRahim Zulfiqar Ali's profile photo
6 comments
 
+Hessel de Walle  Please share the VBA if possible. Meanwhile I am trying +Sumit Bansal suggestion for creating Data Validation.
Add a comment...
In their Group F World Cup match late last month, Argentina and Iran were still deadlocked after 90 minutes. With the game in stoppage time and the score tied at 0-0, Lionel Messi took the ball nea...
1
Add a comment...
 
WEEKEND EXCEL TIP:
"Generate a Random Sentence in a Cell"
[ DASHBOARD TIPS & TRICKS ]

=IF(B4="Generate Sentence",INDEX(B11:E11,ROUNDUP(RAND()*1,0),ROUNDUP(RAND()*4,0)),FALSE)
1
1
Gerry Keating's profile photo
Add a comment...
Have him in circles
407 people
Ashley Bower's profile photo
Shehla Asad's profile photo
nida abdulali's profile photo
Faisal Velji's profile photo
Israr Uddin's profile photo
Munir Nizar's profile photo

Rahim Zulfiqar Ali

Shared publicly  - 
 
 
Ever wonder how to resize your ranges automatically based on your current data?  Learn 5 ways to dynamically find either the last row or last column in a data set with VBA. #BeTheOfficeExpert
Learn how to make your VBA code dynamic by coding in a way that allows your macros to automatically expand and collapse based on the size of each individual data set.
1
Add a comment...
 
"Locking Cell depending on other cell value" (To be applied on many rows)
e.g. 1 in Cash Book sheet, until date (B11) is written no subsequent cells in row are not available (C11 and onwards) i.e. locked. 
e.g. 2 if nature of receipt is mentioned (F11) then amount column of receipt is available (H11) and not payment amount column (I11).

Any possible solution via VBA ? or other excel feature !!!
2
Michael Leng's profile photo
 
Thank you for this tip.
Add a comment...
 
"Locking Cell depending on other cell value" (To be applied on many rows)
e.g. 1 in Cash Book sheet, until date (B11) is written no subsequent cells in row are not available (C11 and onwards) i.e. locked. 
e.g. 2 if nature of receipt is mentioned (F11) then amount column of receipt is available (H11) and not payment amount column (I11).

Any possible solution via VBA ? or other excel feature !!!
1
Add a comment...
In their Group F World Cup match late last month, Argentina and Iran were still deadlocked after 90 minutes. With the game in stoppage time and the score tied at 0-0, Lionel Messi took the ball nea...
1
Add a comment...

Rahim Zulfiqar Ali

Shared publicly  - 
 
 
Send in your tips for next week.  Excel Challenge - Winners 
+Rahim Zulfiqar Ali +X Szil and Heather Gray
http://youtu.be/2imIwGu6aNA
3
Add a comment...
People
Have him in circles
407 people
Ashley Bower's profile photo
Shehla Asad's profile photo
nida abdulali's profile photo
Faisal Velji's profile photo
Israr Uddin's profile photo
Munir Nizar's profile photo
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Karachi
Links
Education
  • ICAP
    present
Basic Information
Gender
Male