View Single Post
 
Old 02-23-2023, 02:08 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

the @ means refer to the same row in that column.
Without the @ refers to whole column.
You can see it when you edit the formula in the formula bar (the formula parts are highlighted in the same colour as the boxes around the ranges):


2023-02-23_210650.png


You don't need to type these references in. If you use the mouse to select ranges while you're building the formula, they will appear automatically.
Reply With Quote