General

Search Capability
I really like and use these discussion groups. They are invaluable. My concern is the search capbility is no longer as good as it used to be. I used to be able to search on my name. Now this feature only finds very old posts, not the few I've created this year. The search doesn't seem to be looking at all ... 23 Apr 2010 18:11

How do I find duplicate entries in a column in an Excel worksheet?
Will this same process work for three columns of data, not necessarily concurrent. I want to ID duplicates where data in A, B and C are all the same? If so can you help me with the detailed formula to write? Thanks! DebDSD "Chunka" wrote: I am working with Excel 2000. I have two columns. Column A ... 23 Apr 2010 15:00

Drop down list
How do you display drop down list button even if the cell is not selected? ... 23 Apr 2010 16:11

Opening Excel File Blank One Day and There The Next
I have Excel 2002 and am using Vista. I have never had a problem like this before and nothing has changed. I open my Excel file - enter the data - and save to my hard and thumb drive. This is done consistantly...daily. Lately I open the same excel file and it is blank - no entered information - just an open ex... 23 Apr 2010 16:11

PLease HELP - Track Changes not working right
The history on Track changes is not always showing up. Neither is the Reject and Approve changes i select it and the box ask what to go through and then nothing happens. When i choose show list on a separate sheet nothing happens. This is on a shared workbook. Also i want to be the only one on the shared bo... 23 Apr 2010 13:55

How can I autofill not using adjacent cells
I have a formula: =SUM('Daily from Mar 2010'!AZ4:BF4) In the cell to the right of the above cell I want the formula to be =SUM('Daily from Mar 2010'!BG4:BM4) Whenever I try to use autofill it populates the cell with the following formula instead: =SUM('Daily from Mar 2010'!BA4:BG4) I really need it ... 23 Apr 2010 13:55

Can't open already opend files since changeover.
Before: Windows XP, Excel 2003. When clicking on a network spreadsheet that someone else has opened, after a second a box comes up giving you the option of opening it in read only, or being notified when the file is closed. Now: Windows 7-64, excel 2007. When clicking on a network spreadsheet that someone e... 23 Apr 2010 12:52

Maximum Row Height Greater than 409.5
I read and Googled how I can increase the height of a row in Excel. Someone suggested merging two cells together. When I tried that, Excel came back and warned me that it would inly keep the Upper Left-Hand column and it didn't lie. I have data in columns A thru E. How can I keep the data and make the row hei... 24 Apr 2010 13:54

lookup an address in a worksheet
Hi!! I hope I can do this because it would make my job so much easier. I have 6 workbooks. One workbook has a list of new clients on it (I'll call that file Gains) the other 5 have potential clients (I'll call those files PC1, PC2, PC3,etc). I would like to put a formula in the workbooks named PC that would ma... 23 Apr 2010 12:52

How to do a formula counting the number of hours between 2 times?
We have some employees who work during a time which has a different hourly rate than their usual rate. How can we do a formula that counts the number of hours between 11 PM and 6 AM? The cells it would be looking at are coming from an input log's cells that are formatted like this- 11:00 PM. We know how to make... 23 Apr 2010 18:11