Replies

Perhaps your PST is attached as a data file in her Outlook profile. If you visit the Mail Control Panel, you can check on the details of each of your Outlook profiles. Make a backup before adding or delete data files, just in case.

Thanks for the direction. So, where’s the “Mail Control Panel”? I don’t see anything that even has “Mail” in the title within the Control Panel.

EDIT: I see it on my desktop (same OS), so I need to see why it doesn’t appear on the laptop.

=IF($L2=”No”,”Closed”,”Open”)

or if you want to copy to other columns as well:

=IF(L2=”No”,”Closed”,”Open”)

The dollar signs ($) lock it on the column or row…

Steve

Thanks Steve, I discovered the error right about the time you replied. Thanks for the help!!

Ooops, guess I had dollar signs floating around in my head from other formulas. I removed them from this one and all is well – sheeesh!

Try the “old one” of closing Word, locating your wife’s version of Normal.dot (C:Users[username]AppDataRoamingMicrosoftTemplatesNormal.dot), renaming it to (say) Normal_.dot and then reopening Word. Tends to work most times…….. HTH

Great solution Malcolm, we truly appreciate the help!

Is there something we did to cause this issue? How can we avoid it in the future?
Again, thank you for delivering us out of this trouble!

Make sure that “Allow default shortcut menus” under “Toolbar Options” is ticked.

Added: too late!

Never too late. Thanks!

This was unchecked. All is well now. . .thanks!

I can’t open any databases in 2007 with the Return Key so I can’t investigate this properly. The Return Key opens them in 2003 on my computer.

But I can use right click filtering, and I don’t think I have done anything special to make it possible. I get a right click menu like this:

I only get it when the control is enabled.

If you don’t use the Return Key, how do you open the database? There are a number of ways of opening a database so I am wondering which method you use.

Sorry John, I meant the Shift key, not the Return key. I hold down the Shift key and click on the db shortcut. If I don’t use the Shift key, I don’t get the menu you attached; if I do open the db with the Shift key held down, I get the menu.

Did you mean the Shift key instead of the Return key?

You can view and change the startup options for the database as follows:
– Open the database with the Shift key held down.
– Click the Office button.
– Click Access Options.
– Click Current Database in the left hand pane.

Ooops, yes I mean the Shift key and not the Return key. I did look through the options but didn’t see anything that would turn on or off the right-click functionality.

Did you use Ctrl+Shift+Enter to confirm the formula? If so, you should see brackets { } around the formula in the formula bar.
If not, edit the formula, don’t change anything, then press Ctrl+Shift+Enter.

(Also keep in mind that the formulas posted by WebGenii and sdckapr apply to column A – you have to modify them for column

Thanks Hans, I did use ctrl+shift+enter and did discover the brackets. I didn’t change anything. In any case, and while I am grateful for the other solutions, your solution answered my question and works quite well.

You may have to settle with some XL versions with the array (confirm with ctrl-shift-enter):
=INDEX(A1:A65535,MAX(NOT(ISBLANK(A1:A65535))*(ROW(A1:A65535)),1))

Earlier versions did not allow using the full column in the array formula…

Steve

With this, my result is zero.

Here is a more elegant and robust formula from Dick Kusleika
{=INDEX(A:A,MAX(NOT(ISBLANK(A:A))*(ROW(A:A)),1))}

I like a couple of things about this formula
1 – it will recognize both text and numbers
2 – blanks don’t bother it

Finally, I think the core of the formula {=MAX(NOT(ISBLANK(A:A))*(ROW(A:A)),1)} will be useful for finding all sorts of “last cell” variations.

With this, my result is zero.

You can make one of the characters bold, for example. I typed this: [b]b[/b]B[b]/b[/b]) to get B)

You are always so creative. Thanks!

This version of the Lounge uses shortcuts for smileys, e.g. :) becomes and B) becomes
If you want to use one of those shortcuts as “normal” text, you have to be very careful…

I kinda figured. . . so what’s the trick? Top secret stuff?

I think you are blending two different formulas from that previous post Final Value in a Column
There were two options offered:
=LOOKUP(9.99999999999999E+307,A:A)

and I see Hans has beat me to the rest …

Hey! It happened again when I quoted Hans in my reply to him.
I leave for a few months, come back, and then break the Lounge – GREAT!

Try

=INDEX(B:B,MATCH(9.99999999999999E+307,B:)

or somewhat shorter

=LOOKUP(9.99999999999999E+307,B:

If you only want to look at B6:B365:

=LOOKUP(9.99999999999999E+307,B6:B365)

Thanks friend! I opted with the last one and it works great.