By Hasaan Fazal on September 19, 2014
Tip # 11: Select only where specific column(s) and row(s) intersect
If you type A:D 3:8 and press enter you will select the intersection i.e. range enclosed inside cell A3 through D8. Pay attention to the space between D and 3. And also to know the area of intersection simply take first column of the range you mentioned with first row of the range you mentioned that gives you first cell of the range i.e. A3. now you can workout the other cell of the range 
<< Tip# 10 | Tip# 12 >>
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Posted in Excel |
Teaching professional business subjects to the students of FIA, ACCA, CIMA, CA etc. He also found ACCA LIVE which is Pakistan's first portal to provide online classes and distance learning solutions to FIA/ACCA students. At PakAccountants.com he is busy making study material for different qualifications. Beside writing articles he answers questions asked using ASK TUTOR!
