ExcelBanter - what it means in a range (B:B)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what it means in a range (B:B) (https://www.excelbanter.com/excel-discussion-misc-queries/82839-what-means-range-b-b.html)

starguy

what it means in a range (B:B)

i noticed some refrences in formulas like column B:B. this do not
contain row number. what it stands for?

--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=532214

MageeStringer

what it means in a range (B:B)

This includes all the rows in column B

--
MageeStringer
------------------------------------------------------------------------
MageeStringer's Profile: http://www.excelforum.com/member.php...o&userid=33298
View this thread: http://www.excelforum.com/showthread...hreadid=532214

Bob Phillips

what it means in a range (B:B)

All of column B.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"starguy" wrote in
message ...

i noticed some refrences in formulas like column B:B. this do not
contain row number. what it stands for?

--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=532214

All times are GMT +1. The time now is 01:19 PM.