Thread: [Solved] Problems with lookup/search Formula
View Single Post
 
Old 10-24-2022, 01:07 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
One possible way.

After getting a new (calculated) table, you can replace all formulas in it with values (Copy - PasteSpecial>Values), and after that you can delete the original table.
Attached Files
File Type: xlsm FillColumnsExample.xlsm (12.0 KB, 11 views)
Reply With Quote