Q. How to specify a column range according to a formula in Excel?
chris

My credo : #Improve


How to specify a column range according to a formula in Excel?

I’m trying to calculate a formula based on a column of data, and I want to choose the column based on a number in an adjacent cell. But seem I can’t figure it out …


formula windows excel
1

Answer

42

Views

2

May, 2018

Computer
 44.6 q
Accepted Answer
  • mihbor

    You can use the INDIRECT function. It takes a cell/range as a parameter (as text) and you can construct that based on the value of another cell like you want.


       

    answered by

      2.66 q

Asked in Category

Computer

Have you tried using typewriters for your documents and any paperwork? Typewriters are now replaced with computers. Nowadays, computers are everywhere. There is no place that doesn't use computers. For the love of computers, a person has at least an idea about its history. The ones we have in the present are not the ones we had in the past that were huge and noisy. The computers in the present are smaller and can be brought anywhere. There are also computers that are designed for specific tasks like gaming or video editing. There are so many things we can do with computers. Paired with a computer expert, this machine can make all transactions faster.

  • 42 views overall.
  • Asked on