BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 274
- Office Version
- 365
- Platform
- Windows
hey I have a long list of formulas in a column, around 30k rows. I've noticed every so often some of the cells don't have a formula but are hard coded with data. Is there a way to sort by the formulas rather than the data showing?
e.g. I have a bunch of similar formulas like this:
=IF(C119<>"",LOOKUP(C119,ZoneDItems1!A:A,ZoneDItems1!C:C),"")
but then every so often someone has just typed the data
e.g. I have a bunch of similar formulas like this:
=IF(C119<>"",LOOKUP(C119,ZoneDItems1!A:A,ZoneDItems1!C:C),"")
but then every so often someone has just typed the data