Forum Discussion
pperry
Mar 31, 2020Copper Contributor
Excel Formula
Hello Everyone, I am fairly new to using Excel and just had something dropped in my lap that I have to deal with. We had a former employee create a form that autofills with information from a progra...
pperry
Mar 31, 2020Copper Contributor
Hello,
I range does mean what I thought it did, but I haven't been able to understand how the range is figured between the two columns. If it was A12:A48 I understand that.
Thank You
I range does mean what I thought it did, but I haven't been able to understand how the range is figured between the two columns. If it was A12:A48 I understand that.
Thank You
Haytham Amairah
Mar 31, 2020Silver Contributor
This range A12:B48 is a group of cells (grid) within the sheet Receipt Types.
The formula used that syntax to refer to it.
The range starts from cell A12 to cell B48 which is 2 columns by 37 rows.
This is how the range looks like in the sheet when you highlight it:
- pperryMar 31, 2020Copper Contributor