-
Anonymous users2024-02-06Just learn a VBA and you'll understand, it's simple.
-
Anonymous users2024-02-051. Column A automatically displays the problem: the simplest thing is to enter the formula "=if(and($h 1<> in A1"j1<>"Unknown",if($h1<>"It worked",if($j1<>"Invalid","Copy this formula for the cells below it; You can also enter the formula unknown in any cell in column A",if(indirect("$h"&row()) works",if(indirect("$j"&row()) is invalid","Copy this formula for the rest of the cells that are also to be displayed automatically.
2. The problem of automatic display of K columns: the simplest thing is to enter the formula "=if(and($b 1<> in the K1 of Xunkong Bend"d1<>"e1<>"Class A","Mu stuffy"Copy this formula for the cells below it; You can also enter a formula class in any cell of column k","Copy this formula for the rest of the cells that are also to be displayed automatically.
3. Create a marker column, such as column L, enter the formula "=$b 2&$d 2&$e 2" in L1, then select column B, column D, column E (press the Ctrl key, click the column label position with the mouse to select), then click the 'Data Validity' button in the data menu, select 'Allow' in the 'Allow' tab of the open data validity dialog box, and enter the formula in the 'Formula' If you encounter a prompt: "The formula currently contains an error." Do you want to continue? and select Yes); Then, in the 'Error Warning' tab of the Data Validity dialog box, select 'Warning' for 'Style', set 'Title' to 'Prompt', and set 'Error Message' to 'Duplicate Found'. ', OK to exit. After the above settings, when the content of the three columns is the same, a prompt box will appear, and the prompt content will be "Duplicate found.
Do you want to continue? There are four buttons in the prompt box: 'Yes', 'No', 'Cancel', and 'Help', select 'Yes' to continue the operation, and 'No' needs to be revised.
4. The simpler way is that as long as you close the file, filter the K column to "Class A" and then save the closed file, the K column will only show "Class A" when you open it next time.
-
Anonymous users2024-02-04DateDiF() is a function to compare the value of the date difference, the usage is: =datedif(start date, end date, parameter), the parameter in this formula is an array, so =datedif(b7,c7,) returns the number of days between b7 and c7 regardless of the number of years and the number of years, that is, {day, year} such an array, where {} is the array symbol, datedif(b7,c7,)*
What this function does is differentiate the date by the number of days - because its yd (day) is exactly *1 and y (year) is exactly *365
text(b7:c7,"md"-229=0 is a Bollinger value with a value of true or false
The () function is to convert a text value or a logical value into a number such that --(text(b7:c7,"md"-229=0) can be a number, if true, it will return 1, if it is fasle, it will return 0
sumproduct() multiplies the corresponding elements in the array and returns the sum of the products. (sumproduct(--text(b7:c7,"md"-229=0))>0), which is actually used to find the number of days from b7 to c7 equal to 229 days.
Note: b7:c7 is a region, which itself is a one-dimensional array.
I tested it, and the part I drew was wrong, please check if it's abnormal when you use it.
Chinese culture has a long history, and there are countless allusions to the characters. Famous stories of historical figures include Yanhuang Zhuolu Central Plains, Shennong tastes Baicao, Dayu controls the water, Shang Tang extinguishes Xia, Pangeng moves to Yin, King Wu of Zhou fights, Jiang Taigong fishes, Zhou Gong asks for gifts, Zhou Youwang Fenghuo Opera princes, King Zhou Ping moves east to Luoyi, Qi Huan Gong fights for hegemony, Chu Zhuang King wins, Yue Wang Goujian lies on the salary and tastes gall, Guan Zhong reforms, Zhao Wuling Wang Hufu cavalry shooting, Li Kui changes the law, Wu Qi changes the law, Shang Yang changes the law, Qin Shi Huang unifies the six countries, Chen Sheng Wu Guangze Township unveils the uprising, Liu Bang about the law three chapters, Xiang Yu Julu battle, Chu and Han fight for hegemony, Emperor Wu of the Han Dynasty deposed the hundred schools, respected Confucianism alone, Huo Qubing defeated the Xiongnu and sealed the champion Hou, Zhaoxing Zhongxuan, Wang Mang reformed, the Eastern Han Dynasty Red Eyebrows, Green Forest, Liu Xiu uprising, Dong Zhuo entered Beijing, Cao Cao assassinated Dong Zhuo, Liu Bei, Guan Yu, Zhang Fei, Taoyuan three knots, Liu Bei Sangu Maolu, invited Zhuge Liang, the battle of Guandu, the battle of Chibi, Cao Cao defeated Huarong Dao, Zhuge Liang seven out of Qishan, Sima Yan established the Western Jin Dynasty.
There are 5 types of Japanese language proficiency tests, which are divided into N1, N2, N3, N4, and N5, with N1 being the highest level and N5 being the lowest. Because it has the highest recognition, it has become the main choice for many students, especially undergraduates. >>>More
I think a large passage from Harukami Muraki's "Norwegian Wood" seems quite interesting to excerpt: The fish says to the water: You can't see my tears, because I'm in the water. >>>More
Presentation skills mainly include expressionsExpressionand rhetorical devices, among others. Let's take a closer look at these three parts. >>>More
It would be nice to use vegetable cakes because they are very fragrant.