Formula Forensics 003
- Thread starter cacos
- Start date
shrivallabha
Excel Ninja
1. You can keep sheet calculation in "Manual" mode. And then calculate sheet as and when needed i.e. when you want to see updated data. This wouldn't slow down the sheet during work / data input.
2. You can also try pivot table but it will require few more steps every time to adjust the data / filters.
3. Using VBA is also possible but then you need to run the code to get updated data.
2. You can also try pivot table but it will require few more steps every time to adjust the data / filters.
3. Using VBA is also possible but then you need to run the code to get updated data.
Ok I'll see if I can code it somehow. Thank you. Going back to the formulas issue, I'm struggling with this formula that I use to remove the duplicates:
=IFERROR(INDEX(List1,MATCH(0,COUNTIF($K$13:K17,List1),0)),"")
Somehow it doesn't recognize cells that begin with the character <, such as "<b>Blablabla(1)</b>
Does anyone know how i could make it pick up this category?
=IFERROR(INDEX(List1,MATCH(0,COUNTIF($K$13:K17,List1),0)),"")
Somehow it doesn't recognize cells that begin with the character <, such as "<b>Blablabla(1)</b>
Does anyone know how i could make it pick up this category?