Thread: [Solved] A 20k lines Sheet calculation takes 1,23 hours!!
View Single Post
 
Old 11-05-2022, 07:45 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
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
Do you need to see the intermediate results in column K:Q?
Why are you using CELL("Contents"… ?
Won't referring to the cell directly do?
=IF(K1<>"-",A1," -")
and if you need to see a leading zero, custom format those cells with 00.
Direct result without intermediate:
=IF(COUNTIFS($A$1:$G$9,A1)>=$I$1,A1, " -")
Reply With Quote