Forum Discussion
Excel Equation Not Working?!
I need an equation (that works) to show the value of a cell in a different sheet. for example: Sheet1 has Column A as a person's name. Column B, C & D have numbers 1-60 listed. (So each person could...
RVLIES905 Please see attached workbook containing three possible solutions.
In Sheet2, column B contains a formula that works in all Excel versions. Column D works only in MS365 and 2021. Column G contains PowerQuery output. The latter can be viewed, edited and refreshed in Excel for the PC (later than 2013). It can be refreshed only in Excel for the Mac. See which one works best for you.