create account

COLUMN function by excelsheets

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-167922 · @excelsheets ·
$0.24
COLUMN function
![COLUMN Function](https://images.hive.blog/DQmP7zEAE6WR7w2wjeB8Lyd4U9kNntrxf5gAcQvafxnfiHX/COLUMN%20Function.png "COLUMN Formula in Excel or Google Sheets")

---
#### **Function Type:** 
Lookup and Reference

---
#### **Description:**
The **COLUMN** function in Excel or Google Sheets returns the column number of a reference.
Although we see alphabet being utilized as column indicators, this function would return a whole number.
A - 1
B - 2
C - 3
D - 4
E - 5

It is useful and frequently used combined with other Lookup and Reference functions such as [INDEX](https://leofinance.io/@excelsheets/index-function "INDEX function in excel or google sheets"), [VLOOKUP](https://leofinance.io/@excelsheets/vlookup-function "INDEX function in excel or google sheets"), [HLOOKUP](https://leofinance.io/@excelsheets/hlookup-function "HLOOKUP function in excel or google sheets"), OFFSET and ADDRESS.

I've personally used this function yesterday for my freelance service to a client together with [ROW](https://leofinance.io/@excelsheets/row-function "ROW Formula in Excel or Google Sheets") function. I used COLUMN function to find the column location of [cell](https://leofinance.io/@excelsheets/excel-cells "Excel Cells")  that is equal to the value that I am looking up in a [range](https://leofinance.io/@excelsheets/excel-range "Excel Range").
~~Imagine using VLOOKUP, but in reverse.~~

---
#### **Function Structure:** 
=COLUMN(*reference*)

---
#### **Argument Breakdown:**
*reference* - A reference to a [cell](https://leofinance.io/@excelsheets/excel-cells "Excel Cells") or [range](https://leofinance.io/@excelsheets/excel-range "Excel Range") of cells.

> PRO TIP:
If you leave this argument blank, the COLUMN function will return the row number of the cell that the formula is in.
=COLUMN()
![COLUMN formula without argument](https://images.hive.blog/DQmWGFctWdnrv4eYnsRj2mXuaE7zeWFcdtZSJ1DrwpKaR7s/image.png "COLUMN formula without reference")
![COLUMN formula without argument result](https://images.hive.blog/DQmNtcPNxH71YvBBQbzr1epnYKfAVT16x1HME6VBAyb4WFE/image.png "COLUMN formula without reference result")

---
#### **Example:**


##### Finding the COLUMN number of a [cell](https://leofinance.io/@excelsheets/excel-cells "Excel Cells")

![COLUMN number of a cell using cell reference](https://images.hive.blog/DQmVj8nG1hfeSPrUgBinUA9JdXMDAw67mb2JXcDyEQmnRgj/image.png "COLUMN function spreadsheet")

In the image above, we are asking Excel on which column do we find [cell](https://leofinance.io/@excelsheets/excel-cells "Excel Cells") D2.
I know this function sounds silly (~~and useless~~) right now, but you'll see why we need this function when you start combining this with the other Lookup and Reference functions.

---
##### Finding the COLUMN number of a [range of cells](https://leofinance.io/@excelsheets/excel-range "Excel Range").

![COLUMN number of a cell using cell range reference](https://images.hive.blog/DQmVPb15VFDTYudtNzjBYAetWaY23MFa588ut1J28dD8w9k/image.png "COLUMN function spreadsheet")

When we use COLUMN function with a [range of cells](https://leofinance.io/@excelsheets/excel-range "Excel Range") as reference like in the image above, we get the first column of the [range](https://leofinance.io/@excelsheets/excel-range "Excel Range").


---
Still need help with Excel and Google Sheets?
[Get Instant Expert Help in Fiverr](https://www.fiverr.com/share/ey8E6m "Excel Help")
[Get Instant Expert Help in PeoplePerHour](https://www.peopleperhour.com/hourlie/give-instant-expert-help-with-excel-and-google-sheets/712968?ref=member "Google Sheets Help")
We can also accept [LEO](https://leofinance.io/@leoglossary/leoglossary-leo "LEO crypto token"), [HIVE](https://leofinance.io/@leoglossary/leoglossary-usdhive "HIVE crypto token"), [HBD](https://leofinance.io/@leoglossary/leoglossary-hive-backed-dollar-hbd "HBD stablecoin crypto token") tokens as payment.

---
This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉


Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn [HIVE](https://leofinance.io/@leoglossary/leoglossary-usdhive) in 7 days while blogging your favorite topics, join us here at [Peakd](https://peakd.com/register?ref=cashheaven). 
*Thumbnail used is made in Canva.

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@excelsheets/column-function)
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authorexcelsheets
permlinkcolumn-function
categoryhive-167922
json_metadata{"app":"leofinance/0.2","format":"markdown","tags":["excel","sheets","neoxian","mancave","formula","functions","excelforall","education","leofinance"],"canonical_url":"https://leofinance.io/@excelsheets/column-function","links":["https://leofinance.io/@excelsheets/index-function","https://leofinance.io/@excelsheets/vlookup-function","https://leofinance.io/@excelsheets/hlookup-function","https://leofinance.io/@excelsheets/row-function","https://leofinance.io/@excelsheets/excel-cells","https://leofinance.io/@excelsheets/excel-range","https://www.fiverr.com/share/ey8E6m","https://www.peopleperhour.com/hourlie/give-instant-expert-help-with-excel-and-google-sheets/712968?ref=member","https://leofinance.io/@leoglossary/leoglossary-leo","https://leofinance.io/@leoglossary/leoglossary-usdhive","https://leofinance.io/@leoglossary/leoglossary-hive-backed-dollar-hbd","https://peakd.com/register?ref=cashheaven"],"image":["https://images.hive.blog/DQmP7zEAE6WR7w2wjeB8Lyd4U9kNntrxf5gAcQvafxnfiHX/COLUMN%20Function.png","https://images.hive.blog/DQmWGFctWdnrv4eYnsRj2mXuaE7zeWFcdtZSJ1DrwpKaR7s/image.png","https://images.hive.blog/DQmNtcPNxH71YvBBQbzr1epnYKfAVT16x1HME6VBAyb4WFE/image.png","https://images.hive.blog/DQmVj8nG1hfeSPrUgBinUA9JdXMDAw67mb2JXcDyEQmnRgj/image.png","https://images.hive.blog/DQmVPb15VFDTYudtNzjBYAetWaY23MFa588ut1J28dD8w9k/image.png"]}
created2023-01-11 23:25:09
last_update2023-01-11 23:25:09
depth0
children2
last_payout2023-01-18 23:25:09
cashout_time1969-12-31 23:59:59
total_payout_value0.120 HBD
curator_payout_value0.118 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length4,428
author_reputation1,449,141,605,578
root_title"COLUMN function"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id119,805,766
net_rshares483,672,523,497
author_curate_reward""
vote details (34)
@hivebuzz · 
Congratulations @excelsheets! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

<table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@excelsheets/comments.png?202301130122"></td><td>You made more than 50 comments.<br>Your next target is to reach 100 comments.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@excelsheets) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



**Check out our last posts:**
<table><tr><td><a href="/hive-122221/@hivebuzz/lpud-202301"><img src="https://images.hive.blog/64x128/https://i.imgur.com/pVZi2Md.png"></a></td><td><a href="/hive-122221/@hivebuzz/lpud-202301">LEO Power Up Day - January 15, 2023</a></td></tr><tr><td><a href="/hive-199963/@hivebuzz/meetup-graz"><img src="https://images.hive.blog/64x128/https://i.imgur.com/5KV6zT3.png"></a></td><td><a href="/hive-199963/@hivebuzz/meetup-graz">HiveBuzz supports meetups of the Hive Austrian Community in Graz</a></td></tr><tr><td><a href="/hive-139531/@hivebuzz/proposal-2324"><img src="https://images.hive.blog/64x128/https://i.imgur.com/RNIZ1N6.png"></a></td><td><a href="/hive-139531/@hivebuzz/proposal-2324">The Hive Gamification Proposal Renewal</a></td></tr></table>

###### Support the HiveBuzz project. [Vote](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22248%22%5D&approve=true) for [our proposal](https://peakd.com/me/proposals/248)!
properties (22)
authorhivebuzz
permlinknotify-excelsheets-20230113t013651
categoryhive-167922
json_metadata{"image":["http://hivebuzz.me/notify.t6.png"]}
created2023-01-13 01:36:45
last_update2023-01-13 01:36:45
depth1
children0
last_payout2023-01-20 01:36:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,614
author_reputation369,432,312,084,136
root_title"COLUMN function"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id119,833,354
net_rshares0
@poshtoken ·
$0.04
https://twitter.com/1585112629835870211/status/1615465760113192962
<sub> The rewards earned on this comment will go directly to the people( @excelsheets ) sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.</sub>
👍  ,
properties (23)
authorposhtoken
permlinkre-excelsheets-column-function32645
categoryhive-167922
json_metadata"{"app":"Poshtoken 0.0.1","payoutToUser":["excelsheets"]}"
created2023-01-17 21:48:24
last_update2023-01-17 21:48:24
depth1
children0
last_payout2023-01-24 21:48:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.035 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length270
author_reputation5,596,969,104,537,177
root_title"COLUMN function"
beneficiaries
0.
accountreward.app
weight10,000
max_accepted_payout1,000,000.000 HBD
percent_hbd0
post_id119,965,269
net_rshares130,502,654,150
author_curate_reward""
vote details (2)
Help/Feedback