General

# of workshhets in a file
Hi I am trying to use =COUNTA('*'!A1) to calculate the number of non blank sheets I have in a workbook. It works well, however I need this to calculate for many cells and everytime someone adds a worksheet I have to re-enter the calculation as the * is replaced with the actual values each time. Is there anyway to ch... 13 Apr 2010 16:13

Reverse / Mirror Image of Text
I am trying to change the text in only certain cells of my spreadsheet in Excel to read backwards. Not just the letters in a different order, but the individual characters facing backwards. As if you were looking at a mirror image or like a left-handed check mark. Does anyone know how to do this? -- griowa8... 13 Apr 2010 13:58

page breaks won't reset, 1 page is now 4
I created a document in Excel that has been only 1 page. When opened today, it is now 4 pages with page breaks inserted dividing up the page. Page break reset doesn't work, neither does trying to move them. I need for the page to be back to only 1 page ... 13 Apr 2010 13:58

From share drive particular excel file takes long time to open
Hi All, In our environment we have shared folders and files. Excel file is shared and able to open by all who have been given access without any issues. But particular for one user in her system the excel file open is getting delayed. It is taking 15-20min and after that it is getting locked. But at the same ... 13 Apr 2010 12:50

To much space in my cell?
I have a half inch of space in my cell at the top and I go format cell and do an auto row hight fit and nothing happens. How can I make my date fit into my cell. When I try and manualy make the cell to fit the data the data at the botten dissapears and the top still has the half inch of space. ... 13 Apr 2010 17:22

Macro Help Needed
I have a macro to send emails which used to work but now doesn't. Whilst running it within VB it flags an error with this part:- 'Execute the URL (start the email client) ShellExecute 0 &, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus I can't work out why because as far as i can tell nothing ha... 13 Apr 2010 11:43

Averaging unique values
Hi all, I have rows of data being recorded for different dates. The number of data points for each date changes (normally 1-4). Since I don't know in advance how many data points will be recorded for each date I can't set-up an average for each day. Is there a way to find and list unique dates and then get an ... 14 Apr 2010 05:31

IF
I am guessing that it's an IF Column H: Sums the total of client Column A: keeping track of clients that are "no shows" How can I sum the number of clients in column H but minus the number of clients that are a no show in column A. Thanks for the help!!!! ... 13 Apr 2010 11:43

Average using Sumproduct or ....
I have 12 tabs (same worksheet) that I need to average a number in cell b6. The issue is sometimes there is a zero in b6 and I do not want to count it in the average. example: tab 1, b6=145, tab 2=276, tab 3=0, tab 4= 123, tab 5=0, and so on... What is a good formula? ... 15 Apr 2010 22:35

Conditional Format a range based on 1 cell
In Excel 2003, is it possible to conditionally format a range based on the value in one of the cells in that range. for example I have a record with several columns. Can I change the fill color of the entire row for that record based on the value in one of the cells in that range? ... 13 Apr 2010 10:36