View Single Post
 
Old 01-27-2023, 08:39 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
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

In that case, the likes of:
=HSTACK(Table1[Hdr1],Table1[Hdr2]/2,Table1[Hdr2]^2)
at cell D2. The result is NOT a proper Excel Table, and it won't work if you try to make it a table.



2023-01-27_153524.png


Column E is half, and column F is squared.
Attached Files
File Type: xlsx msofficeforums50314.xlsx (10.7 KB, 8 views)
Reply With Quote