Gerry.
With only a few hours left in your retirement, I thought I would pounce upon the opportunity to wish you Happy Retirement.
Since you don't subscribe to the internet at home, I presume we will not see you on these fora that often.
Happy Star Gazing, Happy Sclupting and Happy Painting...
It should be simple but, I can't seem to think beyond a certain point. I have "Yes" or "No" in column F and I have a text string in column B. If the cell in column F is a "No" then I want verify that either "NoBill" or "No-Bill" is part of the text in the respective cell in column B. So far no...
I had to compare two worksheets with identical columnar data with approximately 500 rows in each worksheet. I searched for solutions and although I didn't persist, all I could find was add-ins or third-party software.
I found a way fo comparing two worksheets with small differences in data...
Hi, I have Windows Vista Home Premium Edition. All of a sudden I am having problems deleting files from Windows Explorer or Recycling Bin. Doesn't happen with all files, only some and they are still there. I get a dialog box with "Discovered 0 Items (0 Bytes)" and it keeps on running through the...
When running queries (or Searches) is there a difference in speed when using AND followed by OR versus OR followed by AND.
In one of our databases putting an OR seems to cause major pain. Since I am not quite sure of which works better, I thought I would toss the question out to see if someone...
This is probably a rhetorical question, but I thought I would ask anyway.
One of my students asked if there is a way to adjust the tiling in the background image that you can insert in a spreadsheet. (Pre 2007 - Format, Sheet, Background; or 2007 - Page Layout, Background)
I usually advise...
Hi.
Does anyone know if there is a way to increase the listbox height. I have 10 items to choose from, listbox shows only 8. I have searched, but have had no joy, so far. (XL 2003)
A man has only two choices: He can be right or he can be happy.
This has also been submitted as FAQ: [Link javascript:openindex(450,450,'http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=450')]FAQ68-7219[/url]
Bullet in a single cell:
This one is easy. Most people know about this one.
Place your cursor at the beginning of the cell; hold the ALT key...
Does anyone know how to do a hanging indent in a cell?
I already know about typing spaces, but when there is fair amount of text, that becomes cumbersome.
(Using XL2003 but,I am pretty sure that if there is an answer, it would be version independent)
A man has only two choices: He can be...
Hi.
I am using version 6.5.5. When I copy a table with objects (mostly Symbols) and paste it in Word or Powerpoint, I only get the text.
What am I doing wrong?
Thanks
I don't particularly care about apathy
Hi, I am having one of those cerebral flatulations.
I want to create a Pivot table of data from 10 months of last year and 2 month of this year in a sequence. That is January follows Dec and Data table starts at March. My results are always Jan, Feb, Mar... etc.
So, what am I doing wrong...
Hi, I need to grab @DocumentUniqueID somehow copy it to clipboard and paste it in another application.
I have tried various combinations of @Text..... @EditCopy...., but no success. Can anyone help with exactly what I need in a macro?
I right click, click doc properties, highlight unique id...
Hey, Skip.
Compliments on sticking it out with us guys for last seven years. Wish I had your kind of dedication.
Here's to (at least) seven more years.
Hope you have a great Christmas, just in case I don't get on board again for a while.
Vita Brevis
My system seems to have a bounus feature on it. Once a day it reboots and one logged in, up pops up the message above. And every other time, the screen resolution goes wonky.
Hp has a fabulous solution for this. Perhaps, one of their five year old child came up woth it. "Turn of your system...
In Excel 2003 when I plot a chart, I can cycle through all the elements of the chart through arrow keys on the keyboard.
Why doesn't that work in 2007? Am I doing something wrong? Have I lost that many brain cells?
I would really appreciate any answers from the many maestros there are now on...
Hi.
I am plotting a stacked bar chartfor the following values:
Rent $750.00
Food $400.00
Travel $220.00
Savings $150.00
Entertainment $200.00
Utilities $280.00
I am trying to add Data Labels to all data points in one step. The amazing MS product let's me insert...
Hi.
I have a system with Vista and office 2007 on it. I want to be able to install Office 2003 as well, seeing how 2007 is so unique. Anyone have any experience with it? I have heard no matter what, 2007 erases old installation when it runs or when you run either version it wants to re-install...
Hi.
I haven't found a way yet. I have four stack column chart where some of the values in the stack are Zero. I wish to label the stacks with Series name, but want to hide the label if the value is Zero.
Anyone ever come across something like this?
Thanks
Member- AAAA Association Against...
In my calculations I needed to get the date for the first day of the week knowing only the week number.
What I came up with is the formula below. There may be a better approach than mine and I would love to find out if there is. And, yes I do know about Date + 7...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.