Forum Discussion
Need help with formula
Hello, I need a formula that can fill in a table with data from multiple sheets but with specific criteria. So for example, I have a sheet that is one specific class that has student names correspond...
Hi Redferris
for this kind of analysis I recommend the use of Power Query / Get & Transform, which you can find in the Data menue.
With this functionality, you can load both source tables in Power Query and combine them with a join. The result can be loaded back to a worksheet.