http://www.idownloadblog.com/2015/12/25/how-to-download-older-versions-of-ios-apps/
This site is dedicated to the people who are interested in Information and technology. I would welcome your new ideas and comments.I believe in "Learn by sharing knowledge"
Tuesday, February 23, 2016
Monday, February 22, 2016
SOME EXCEL FORMULAE
1. Use alphabets as serial:
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
2. Find start date from a schedule(Array):
=ADDRESS(ROW(),MIN(IF(E2:BC2<>"",COLUMN(E2:BC2))),4,1)
3. Find end date from a schedule(Array):
=ADDRESS(ROW(),MAX((E2:BC2<>"")*COLUMN(E2:BC2)),4,1)
1. Use alphabets as serial:
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
2. Find start date from a schedule(Array):
=ADDRESS(ROW(),MIN(IF(E2:BC2<>"",COLUMN(E2:BC2))),4,1)
3. Find end date from a schedule(Array):
=ADDRESS(ROW(),MAX((E2:BC2<>"")*COLUMN(E2:BC2)),4,1)
4. Convert cell name to column name:(Highlighted stands for the cell inquestion)
=IF(ISERROR(INT(MID(BD2,2,1))),LEFT(BD2,2),LEFT(BD2,1))
5. Ghant Chart in Excel(Conditional formatiing)
=AND(D$1>=$B2,D$1<=$C2)
D1=Start Month(Series)
B2=Start Date
C2=End date
Applies to range =$D$2:$P$200
5. Ghant Chart in Excel(Conditional formatiing)
=AND(D$1>=$B2,D$1<=$C2)
D1=Start Month(Series)
B2=Start Date
C2=End date
Applies to range =$D$2:$P$200
Subscribe to:
Posts (Atom)