webnovel
The ChooseCOLS function…

Function ChooseCOLS

2026-07-21 11:31
2026-07-21 13:35

The ChooseCOLS function is used to select a specific column from a set of data based on a specified condition or index and return the column in an array or reference. Its grammar was: =ChooseCOLS(Array, column number 1, column number 2,...). Basic usage example: To extract the first and fifth columns of data from the A1:E10 data area, the formula is =ChooseCOLS(A1:E10,1,5), where A1:E10 is the array data area, and 1 and 5 are the column numbers of the returned array. If there are many column numbers, it can also be expressed in the form of "{1,5}", such as =ChooseCOLS(A1:E10,{1,5}). The default rule for the column numbering of the ChooseCOLS function was to start from left to right. If you wanted to extract columns from right to left, you needed to use negative numbers, such as the first column from right,-1. When searching for a match in reverse, the ChooseColls formula could be used when VLOOkUP was inconvenient. For example, if you want to find the corresponding name in the A1:E4 area of the data source through the code of cell A8 (reverse query), you can first use the ChooseCOLS function: = ChooseCOLS(A1:E4,5,1) to extract the relevant data, and then use the VLOOkUP function: = VLOOkUP(A8,ChooseCOLS(A1:E4,5,1), 2, 0) to search. It also had advanced applications, such as the combination of ChooseCOLS+Match: extracting the data of the corresponding column from the left table according to the order of the fields on the right, the formula was =ChooseCOLS(A2:E10,Match(G1:K1,A1:E1,0)); and the combination of ChooseCOLS+ Filterer: extracting the qualified name and corresponding basic salary from the data of the left table according to the department and seniority information in the right table, the formula was =ChooseCOLS(Filterer (A2:F10,(B2:B10 = H3)*(C2:C10>=I3)),{1,4}). "Choose" was equally exciting. Everyone was welcome to read it!

Latest Questions

The novel where the male lead returns to his hometown to contract the mountain

I recommend " Unlimited Strange Game ". The author is a 19-year-old girl, a top student at Nanjing University's Faculty of Arts. This was a mystery and mystery novel,[Unlimited Style],[No Female Lead],[Dark Text],[Original Instance Dungeon],[Variant Reasoning]. The protagonist, Si Qi, was 22 years old. He was ruthless and absolutely self-serving. In the story, the rules were that the god of food was bright, the gods sacrificed to all living beings, and the strange game was a net. Si Qi was unwilling to let fate throw him off the shackles and break free from the rules. The characters in the book had their own characteristics, and the supporting characters had a lot of information. The script was original, and the thought process was clear. It felt like Feng Bujue, but it was more rational and cruel. The style of writing was exquisite, and the writing was excellent, but it would feel like it was piled up if one continued to read it. It emphasized reasoning and despised strangeness. The layout and plan were well written. It was just that Author's Power for Love updated slowly, so it would be more fun to save it up and watch an instance. The novel " From a Rogue Cultivator to a Big Boss " is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-07-22 16:17

How to adjust the resolution of League of Legends

You can adjust the resolution of League of Legends by following the following steps: First, open the LOL game program and start a custom game. After entering the game, press the esc key on the keyboard to pop up the game settings menu window. It was important to note that the maximum resolution supported in the game depended on the resolution of the computer itself. It was impossible to set it to be higher than the maximum resolution of the original computer. After clicking the " Video " option on the left, you could see the drop-down box for the resolution setting after entering the menu on the right. You could adjust the resolution according to your needs. You could observe it while adjusting it until you adjusted it to the most comfortable resolution. If you didn't know how to adjust it, you could also directly choose the default setting. You can also right-click on the empty space on the desktop, select "display settings", find "display" in the left column, and choose the recommended resolution. If there is no recommendation, generally choose "1920X1080". If you are still not satisfied after setting, then open the game and press the esc key to continue adjusting the game. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-22 16:16

Return to the relationship with ghosts

In ancient China culture,"Gui" and "Ghost" were closely related. In terms of concept," return " had the meaning of death and return. After death, people were considered to be returning, and this state after returning was called " ghost." For example, some people believed that when people lived in the world, they would return to the origin after death. This state of return was described as "ghost", just like the ancients said,"People belong to ghosts","When people die, their spirits ascend to heaven, and their bones return to the earth, so they are called ghosts." Ghosts, return." Therefore," ghost " in a certain sense referred to the state of " return " after death. It was an expression of the concept of life and death in ancient culture. " I Work for Ghost Spirits in the World of Cultivators " is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-07-22 16:16

What are the novels about Pear Blossom Garden?

I recommend Splendid Garden, an ancient romance novel written by Li Huabai. The female protagonist was extremely miserable after she transmigrated. She was broken off from her engagement, chased out by her biological father, and rejected by her uncle. However, she had a golden finger and wanted to start from scratch. The male lead was a military general, and the female lead was blackmailed for money during their first exchange. The female protagonist was a modern agricultural expert. The story had a plot of abusing a scumbag father. It was easy. There were no big plots or bad guys. There were only a few jealous girls and the plot of farm management was interesting. The user reviews were good, and there were even people who tipped him. The Golden Branch Spreading, an ancient romance novel written by Shawu. The Crown Prince disguised as a man was ordered to go out of the palace to do business. After meeting him in Jiangnan, he had a new understanding of himself. The story was full of interesting interactions. " Spring Garden " was an ancient romance novel written by Ri Yuexiao. The female protagonist transmigrated into a servant girl and was bullied and used. However, there were many handsome men, so she began to struggle. "A Thousand Gold in Plain Clothes" was a work of pear blossom white, an ancient romance and classical genre. The female protagonist was originally farming, but suddenly changed to a drama. The story with the prince was very interesting, and the female protagonist even resigned. " Painting a Silk Dress " was a modern romance novel written by Li Huashou. It was about the love story of the female protagonist who accidentally entered a brothel. It advocated equality between men and women and monogamy. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-22 16:16

The Love Story of Yunsheng and the Scumbag

In some stories, there were plots related to Yun Sheng and scumbags. In one of the stories, Yunsheng's fiancé cheated on her sister, and she decisively married the scumbag's uncle. In another story, Yun Sheng was beaten to death by her fiancé with a wine bottle, and her soul transmigrated into Yun Sheng, the eldest daughter of the Yun family. Her fiancé was described as a scumbag, and someone was willing to pretend to be a scumbag to protect her. While waiting for the TV series, he could also read the exciting content related to this site!

1 answer
2026-07-22 16:16

Qin Guan (1)

Qin Guan's Three Songs of the Autumn Sun described the night scenery near Han ditch. After the frost fell, the water in the Han ditch was clear, and the cold stars shone on the side of the boat. He thought that there were no people in the place where the wild rice and cattail grew, but suddenly there was laughter. Through the transition from quiet to lively scenes, he wrote about the beauty of life's journey. The second was about the life at home. The poet grinded tea and cooked tea, taught his son to read, the weather was fine and there was no wind, there were no fallen leaves in the small courtyard, and the green insects spat out autumn silk, showing a sense of tranquility and leisure.

1 answer
2026-07-22 16:16

What kind of lens does landscape photography have?

The following types of lenses are suitable for landscape photography: 1. ** Wide-angle lens **: The focal length is between 24 - 35mm, and the 28mm focal length is especially commonly used in landscape photography. This kind of lens could highlight the prospects and enhance the sense of space in the picture. It was one of the main lens choices for landscape photography. For example, Canon's EF16 - 35mm f/2.8L III USM lens and Nikon AF-S NAKKOR 14 - 24mm f/2.8G ED lens were all wide-angle lenses suitable for landscape photography. The former had excellent optical performance and wide viewing angle, which could be used for landscape and architectural photography; the latter was famous for its excellent sharpness and color reproduction ability. 2. ** Ultra-wide angle lens **: With a focal length below 24mm, it can expand the shooting range and highlight the prospects. It can capture a strong visual impact, but you must pay attention to perspective distortion and backlighting glare. For example, the SonyFE12 - 24mm f/4G provided an extremely wide viewing angle and excellent optical performance; the Fujinon XF10 - 24mm f/4R OIS was specially designed for the Fujinon X-mount with a wide viewing angle and excellent image stabilization. 3. ** Telephoto lens **: Generally, the focal length of 70mm and above belongs to the range of telephoto lens. Common ones include 70 - 200mm, 100 - 400mm, etc. This type of lens could compress space, making the front and background closer to each other, creating an artistic image. The telephoto lens combined with the large aperture could also produce an ideal blurred background effect. However, telephoto lenses were generally heavier. For example, Nikon's 70 - 200mm f/2.8E EFL ED VR was known as the "divine tool for travel photography". It had a wide range of uses, but it was heavier. Canon's 70 - 200mm f2.8L IS II USM had high sharpness at full power, and buyers rarely regretted it. 4. ** Standard zoom lens **: Covers the focal length from wide-angle to medium-focal length. High flexibility, suitable for a variety of scenes, including landscape photography. For example, Canon's RF24 - 105mm f/4L IS USM covered wide-angle to medium-telephoto focal lengths and had good image stability; Nikon's Z24 - 120mm f/4S was specially designed for Nikon's Z-mount, with a wide focal length and excellent optical performance. 5. ** A world-famous large zoom lens (such as 18 - 200mm)**: It is suitable for carrying outside, but due to the large zoom ratio, the image quality is ordinary, and the aperture is small, it is not suitable for creative and commercial use. It is difficult to shoot dream-like effects. It is difficult to shoot in a dim environment. It can be used for daily life records. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-22 16:15

The annual party can't stop the actors and actresses.

In the movie " The Annual Party Can't Stop!" In the movie, Bai Ke played the role of the human resources manager Ma Jie. Bai Ke became famous by dubbing. He once had the classic role of Wang Dachui, and he played an important role in many film and television works. He said that it didn't take too much effort to play the role of Ma Jie because he had experience in working life. Ma Jie had many characteristics of ordinary office workers, such as listening to the leader's speech with trepidation. In the film, he had a lot of scenes with Hu Jianlin, who was played by Dapeng. Their characters portrayed the people in the workplace, and his performance made this ordinary employee the most empathetic character for the audience. Bai Ke did not dream of becoming a big star. He was more concerned about working with like-minded people. He felt that the final presentation of the film was much better than he had imagined. Some of the scenes even moved him so much that he could not help but feel moved. While waiting for the TV series, you can also click on the link below to read the classic original work of "Dafeng Nightwatchman"!

1 answer
2026-07-22 16:15

What is the female author of the novel who forcefully corrected her spine calling for?

I recommend 'The Female Devil of the Holy Church of Transformation'. The author is on the right. This was a funny light novel. The protagonist, Mu Xueqing, was wrongly accused in all kinds of ways. After transforming into a female devil, he would travel the world in a male outfit. The protagonist might be bullied by a girl and cry. Before she transformed, she had a very miserable experience. She lost all her family and transmigrated to a place similar to ancient times. After she accidentally obtained the inheritance of the ancient demon god, she began to torture the noobs. Although his reputation was not good, he was not a bad person. It was currently in the final stages and was a little off track. However, it was very interesting. The author, Old Si Ji, drove steadily and was blocked for several chapters. " An Empress 'Self-Cultivation " was not bad either. The author was Ba Ba, Ben Ba. This was an ancient romance novel. The empress had transmigrated from the world of a female god to the world of a male god. It was a 1v1 with two strong couples, and the lower one was abused by the higher one. The empress had a history of blood and tears as she grew up, and she was also the protagonist. Both the male and female leads were very strong. The character information was detailed, and the book list commented that the plot was sour and cool. It was worth watching how the empress would take revenge. Future Gu Medicine Doctor, by Ming Yuan. The female protagonist was reborn from the powerful queen of a wealthy family to the illegitimate daughter of a noble loser. She was not afraid of her shameless father, vicious stepmother, and arrogant sister. With her superpower, she became the number one iron-blooded military doctor in the Empire. The male protagonist and female protagonist were strong, and there was also the interesting Barbara. The female protagonist was strong, and he could see the female protagonist's thoughts on the doctor profession. "Who told him to handle the case?" The author wanted to sleep like a pillow. In a novel about urban life, the male lead, Gao Mao, was a patrol officer. When he handled the case, the leader felt that the others were slacking off. It felt like a story. 'My Self-Made Cultivation Technique', author, you're talking nonsense. A wuxia fantasy novel that unfolds the legendary story of the Jianghu court in the ancient world. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-22 16:15

What is the highest level of hero in the wild chaos?

The highest level of a hero in the wilderness was 10. It was not that a specific hero could reach the highest level of 10, but that all heroes could theoretically reach the highest level of 10. However, to level up from Level 9 to Level 10, the hero needed to equip the power of starlight. After equipping the power of starlight, the hero's level could be upgraded from Level 9 to Level 10. A level 10 hero had an additional passive skill compared to a level 9 hero, and their combat power was stronger. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-22 16:15
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z