searching formula answers

%3CLINGO-SUB%20id%3D%22lingo-sub-1582426%22%20slang%3D%22en-US%22%3Esearching%20formula%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582426%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20a%20formula%20to%20sum%20several%20columns%20in%201177%20rows.%20I%20now%20want%20to%20know%20which%20rows%20had%20a%20sum%20of%200%20however%20when%20I%20use%20the%20find%20function%20it%20searches%20for%20cells%20that%20have%200%20in%20the%20formula%20not%20cells%20that%20have%200%20as%20the%20outcome.%20How%20do%20I%20search%20for%20cells%20that%20have%200%20as%20an%20outcome%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1582426%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582563%22%20slang%3D%22en-US%22%3ERe%3A%20searching%20formula%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756291%22%20target%3D%22_blank%22%3E%40glazed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20this%20is%20what%20you're%20looking%20for.%20Press%20Ctrl%20%2B%20F%20and%20change%20%22Look%20in%3A%22%20to%20Values.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-08-11%20145535.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211852iF127D9219A49D9C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-08-11%20145535.png%22%20alt%3D%22Annotation%202020-08-11%20145535.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582669%22%20slang%3D%22en-US%22%3ERe%3A%20searching%20formula%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756291%22%20target%3D%22_blank%22%3E%40glazed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlus%20%22Match%20entire%20cell%20content%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I used a formula to sum several columns in 1177 rows. I now want to know which rows had a sum of 0 however when I use the find function it searches for cells that have 0 in the formula not cells that have 0 as the outcome. How do I search for cells that have 0 as an outcome?

2 Replies

@glazed 

Perhaps this is what you're looking for. Press Ctrl + F and change "Look in:" to Values.

Annotation 2020-08-11 145535.png

@glazed 

Plus "Match entire cell content"