View Single Post
 
Old 03-17-2021, 02:03 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Code:
=INDEX(Range,,ColumnNo)
The formula has 3 parameters: Range, RowNo, and ColumnNo. As it must return all rows of return column, the parameter RownNo must be undetermined - what is done leaving the 2n'd parameter out, but keeping the delimiter for it present.

When you delete one of commas, you change the INDEX() formula to one with 1-dimensional range as 1st parameter.
Reply With Quote