A formula-only solution (without helpers etc.) would require a quite complex approach which I haven't thought about yet. Eddie505One option would be with Power Query and requires a "Refresh" when Table1 gets updated. See attached. A formula-only solution (without helpers etc.)...
One might even say it's 3/4 of the way. Certainly without a well-planned design, the result will be challenging to maintain, even if it "works" This file looks like when someone is still not sure how to begin or arrange the flow of data. The file has all the markings of a proces...
Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. Forum Discussion
Forum Discussion Share Resources
[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"Component...
Hi,I have Windows 10 and Microsoft 365 license on a laptop. I have a large Excel table with headers in the first column.For each column, I would like...
[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"Adds buttons to share to various social media websites","fetchedContent"...