RE: new values

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

hi
if your data is layed out as below and you enter each month, this fomula
will pick the last entry in the row.......

=OFFSET(A2,0,COUNTIF(A2:I2,">0")-1)

work this in to your formula or post your formula and i'll see if i can.

regards
FSt1

"Robert-Alpha" wrote:

hi,
I am trying to setup a formula where the formula picks up the information
for the latest month available... for ex., below i have information for Jan
and Feb available - right now my formula picks up February's number and
compares it to another cell... i want to be able to setup the formula in a
way where when march becomes available the formula will pick up march and
compare it to my fixed number. is there a way to do this?

Jan Feb Mar Apr May Jun Jul
1000 1500

.

Relevant Pages

  • Re: Getting the list of Autocorrect enties in word
    ... the auto-correct entries of Office Word 2003 into a text file with a C# ... application.Quit(ref missing, ref missing, ref missing); ... entry = application.AutoCorrect.Entries.get_Item(ref ... other Windows Installer aware setup editor. ...
    (microsoft.public.dotnet.general)
  • Re: 60s Challenge Mod
    ... corner entry velocity was much higher than I thought (maybe the in-car ... The Cobra, well, that's another story... ... actually easy to drive now - probably even easier than any GPL car. ... The Cobra seems unfinished in that the available setup parameters are ...
    (rec.autos.simulators)
  • Re: Happy New Year
    ... Or alternatively one can try and remake Heinrich Wolf's entry by following ... Setup the OnDestroy event for Form. ... Setup the OnTimer event for CreateTimer. ... In reality when I am outside and look at the fireworks... ...
    (alt.comp.lang.borland-delphi)
  • Re: Long Time Samba No Work-Need Expert Help On Samba/Networking-Ahhh, Some Success
    ... different from the default and has no netbios name ... entry which what fixed me. ... a client or server setup? ... client setup on ubuntu machine but suspect I only need ...
    (Ubuntu)
  • Re: Our Maiden Voyage or MH vs. FW
    ... Nothing IMHO compares to a ... storage space and house comfort. ... The MH drives really great, ... difference, though, is the setup time, and the built in Jenny. ...
    (rec.outdoors.rv-travel)