'How I can interprit a particular codes in Excel
I have the following Excel functions and I want to interpret them.
Assuming I have 4 columns and two rows. Rows are continuous data. For the first row for example:
IFERROR((MROUND((AVERAGE(IF((A2:(INDIRECT("RC[-1]",0))<>"")*(MOD(COLUMN(A2:(INDIRECT("RC[-1]",0))),2)=0),A2:(INDIRECT("RC[-1]",0))))),5)),"")Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|