Compare the similarities and differences between two columns of data in excel
How to compare the similarities and differences between two columns of data in Excel: 1. Use conditional formatting, select the first column of data to be compared, and use the "=COUNTIF($B:$B,A1)=0" formula to determine the unit to be formatted grid; 2. Use the VLOOKUP function and use the formula "=IF(ISNA(VLOOKUP(A1,$B:$B,1,0)),"different","same")"; 3. Use the EXACT function and use the formula "=IF(EXACT(A1,B1),"Same","Different")" etc.
Jul 25, 2023 am 10:26 AM
How to use text function to convert date to year
Steps to use text function date to convert year: 1. Create a new excel document; 2. Select the cell in excel to enter the year; 3. Enter the formula "=text (cell, "yyyy") in the cell and click Enter ;4. The year in the date is extracted successfully.
Jun 21, 2023 am 11:57 AM
What are the WPS summation formulas?
The wps summation formulas are: 1. Area summation "=SUM(condition area)"; 2. Mixed summation "=SUM(condition 1, condition 2...)"; 3. Intersection area summation "=SUM( Condition 1 Condition 2)"; 4. Single-condition sum "=SUM((Condition 1=Array 1)*(Condition 2))"; 5. Multiple-condition sum "=SUM((Condition 1=Array 1)* (Condition 2 = Array 2)); 6. Nested FILTER function summary sum "=SUM(FILTER (Condition 1, Condition 2 = Array 1))".
Jun 16, 2023 am 10:44 AM
Sharing practical Excel skills: 4 tips for deleting duplicate values!
Hello everyone! When we usually process data, we often find some duplicate data, which will not only reduce our work efficiency, but also affect our subsequent analysis of the data. Today I will share with you 4 ways to delete duplicate values in Excel without using formulas. Come and take a look!
Apr 26, 2023 pm 05:31 PM
Practical Excel skills sharing: guide you to create a high-end dynamic chart
Dynamic charts are a very commonly used chart in our daily work. Different from static charts, it can display data more intuitively and flexibly, allowing users to conduct interactive comparative analysis. It is a higher-level form of chart analysis. So today I will tell you how to use excel to create a dynamic chart that automatically changes based on time periods. Come and take a look!
Apr 25, 2023 pm 07:38 PM
Practical Excel skills sharing: the magical use of connection strings!
Hello everyone! Using excel to connect strings is a commonly used technique in our daily work. I believe that the most commonly used connection method is "&". But in fact, there are many ways to connect strings in excel, and the seemingly inconspicuous connection string has magical effects in some specific occasions. Are you curious? Hurry up and follow the author's instructions in Picture E and take a look!
Apr 24, 2023 pm 05:35 PM
Sharing practical Excel skills: Understand the classic formula for extracting mobile phone numbers!
How to quickly extract mobile phone numbers in excel has become a common topic. After the advent of CTRL+E, the problems of extracting data have become much simpler. I have to admit that it is indeed a very excellent function. But it is not a panacea, and there are still some data extraction problems that require formulas to solve. Next, the veteran rookie will explain to you the common formulas for extracting mobile phone numbers in Excel, and lead you to analyze the formulas in depth. Come and take a look~
Apr 23, 2023 pm 07:20 PM
Practical Excel skills sharing: Find the maximum and minimum values according to conditions!
Speaking of finding the maximum and minimum values according to conditions in Excel, what do you usually do? Some students may say, use the new functions MAXIFS and MINIFS. Indeed, these two functions updated in the OFFICE 365 subscription version and OFFICE 2019 can directly solve the problem. However, the OFFICE 365 subscription version is charged annually, and OFFICE 2019 can only be installed on the WIN 10 operating system, which feels quite restrictive. In addition to these two functions, is there anything else?
Apr 21, 2023 pm 07:47 PM
Practical Excel skills sharing: 3 tips for quickly calculating mathematical expressions
When we need to uniformly convert mathematical expressions in excel into calculable values, what do friends generally do? This problem seems simple. It seems that it can be solved by just adding an equal sign in front of the expression and pressing the Enter key. But what if it is 1000 rows of data? What about 10,000 rows of data? Making manual changes one by one like this is quite tiring! Below I will share with you 3 batch processing methods to solve the problem in minutes, come and take a look!
Apr 20, 2023 pm 05:57 PM
Practical Excel skills sharing: Let you play with date functions and master 90% of date operations!
How to play with excel date function? The following article will help you understand 90% of date operations. Today there will be more functions involved. I suggest you save it first and then read it~
Apr 19, 2023 pm 06:28 PM
Practical Excel skills sharing: Determine whether a cell contains specific content
Hello everyone! Determining whether a cell contains specified content in Excel is already a commonplace topic. I believe everyone has encountered many similar problems at work. Today I’m going to tell you three common ways to solve this kind of problem, and I’m sure they will work!
Apr 18, 2023 pm 04:50 PM
Practical Excel skills sharing: the use of double-layer pie charts
Hello everyone! When it comes to making column charts, bar charts, and pie charts, I believe everyone has no problem. Just select the data and insert the corresponding chart. But if you want to make a two-layer pie chart, would you still do it? "What? There is also a double-layered pie chart?" Hey, I don't know. Compared with ordinary pie charts, a double-layered pie chart has a clearer structure and can display a variety of data more intuitively. Hurry up and follow the editor to take a look~
Apr 17, 2023 pm 06:13 PM
Practical Excel skills sharing: formula routines for ranking according to conditions
When it comes to ranking data in excel, the first thing that comes to mind is the rank function, but what if you want to rank data according to conditions? Friends, are you confused all of a sudden? It seems that you have not heard of the function of ranking according to conditions. So today I will share with you a formula for ranking according to conditions in Excel. Let’s take a look!
Apr 14, 2023 pm 02:58 PM
Practical Excel skills sharing: One chart to handle data comparison, trend and proportional contribution
Hello everyone! Recently, a classmate in the excel learning group complained about their leader in the group, saying that the leader asked him to display three different projects in one picture, including the data values and trends in 12 months, and also to show various aspects. The proportion of projects in the total data of all projects in this month! After hearing the demand, this classmate's mentality collapsed and he thought, "Boss, how about you give it a try?" Today we will make this excel chart based on the needs of this strange leader!
Apr 13, 2023 pm 05:27 PM
Practical Excel skills sharing: 5 small steps to help you create a high-quality line chart
Line charts are a very common way of displaying data in our daily data visualization, and I think everyone is already familiar with it. Line charts are very simple and everyone can make them, but the line charts produced by different people vary widely. Most people's line charts are generated by directly inserting the default line chart style. Regardless of whether they have made such a line chart carefully, the boss is tired of looking at it just because of this style. Today, this article will teach you how to make a high-quality line chart. Let’s take a look!
Apr 12, 2023 pm 05:43 PM
Hot tools Tags
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
Hot Topics
1393
52
1207
24