Re: Keep certain cells from moving

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: guilbj2 (guilbj2.1bgy2d_at_excelforum-nospam.com)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 20:19:27 -0500

That works perfectly for the formula, but what do I do about losing the
formula when the wrong row is filtered out ?

Say I put the formula in F22. I apply the filter, but the condition
I've set doesn't exist in row 22 for whatever colum I've filtered.
That row, along with the formula, gets hidden. Is there any way I can
freeze the formula in place so that it's not affected by the rows
hidden by the auto-filter ? 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: plonk file
    ... You can always unblock if you think you are losing too much. ... I'm having trouble plonking this MI5 guy because every post is a from ... designed to subvert plonk files. ... Set your filter to get rid of ...
    (rec.sport.billiard)
  • Re: Question about Compression into DAWs
    ... it's like you are recording at 22 bits instead of 24. ... converters, so the bits you're "losing" are noise anyway. ... started your anti-aliasing filter at 24 kHz, ...
    (rec.audio.pro)
  • Re: Large moving average
    ... When you decimate by N you are losing some information. ... This would depend on how good the filter of the Moving Average is. ... avoid aliasing, the decimation might have to be narrower than the ...
    (comp.dsp)
  • Re: Expectations about weight OT
    ... Maybe she is losing that filter between what pops into her mind and ... what comes out of her mouth. ... I don't think my mother's ever had that filter ... ...
    (rec.pets.cats.anecdotes)
  • Re: Can I automatically hide or filter a row?
    ... I read the information concerning auto-filter before I made my original post ... to a reference cell, and it did not seem to pick up the changes automatically ... - I had to request it to filter again by going to the tool bar), ... I would like to create a worksheet that would ...
    (microsoft.public.excel.worksheet.functions)