an excel formula question


i have 176K rows in an excel file , now i need a formula that separates the rows that V column in them are more than 0. i need a command that gets ​some data then make condition or formula for separate them (i cant use filter, i need formula)


i need a command or something like this that get some rows and give me a formula like N column / M column in all of this selected rows are an special number

1 Reply


With your permission, add an excel file (without sensitive data) and explain your plan on the basis of this file.

Knowledge of the Excel version and the operating system would be an advantage.

Advantage for you to get a quick and accurate solution proposal and the advantage for the helpers,

they can help more users in this forum at the same time.

Win-win for everyone.


Thank you for your patience and time.



I know I don't know anything (Socrates)