Traditional Culture Encyclopedia - Traditional stories - Please teach a EXCEL in the innovation of a new form according to some conditions
Please teach a EXCEL in the innovation of a new form according to some conditions
D1:
=IF(LEFT(A1,3)="Computer",ROW(A1),"")
E1:
=IF(RIGHT(B1,2)="Culture",ROW(A1),"")
F1:
=IF($D1<>"" ",IF($E1<>"",A1,""),"")
G1:
=IF($D1<>"",IF($E1<>"",B1,""),"")
H1:
=IF($D1<>"",IF($ E1<>"",C1,""),"")
The effect on the chart appears after the formula is pulled down.
Based on this principle, in another table can also be realized it. Just appear in the line of information to be filtered in order to not appear in the middle of the blank line.
- Previous article:Tea
- Next article: Wuyi Rock Tea
- Related articles
- Please describe in 3-4 sentences what you usually do in the following traditional festivals in China. (Note: Please use English)
- What are the advantages and disadvantages of indoor positioning technology?
- Method of self-made log flowerpot
- Application of geological remote sensing
- Seek for immortal cultivation novels with Chinese traditional romanticism
- What is popcorn? What is popcorn?
- How did the ancients prevent epidemic in ancient times when plagues were frequent?
- Data mining and big data, OLAP, data statistics
- Yixing Zisha Pot Who's Who 2017
- What details should I pay attention to when buying a second-hand house? Know almost