Hello, When i use autofilters, sometimes appaers the count of articles founded, and sometimes not. What do i have to do to to make it appears...

Please can somebody help me out on this problem... I download a text file from external stations which I cut and paste into worksheet 2 (all into column A). In...

I do a monthly stat sheet that lists a member number in column B, in column D is the total number of work done. Each month the list has the same data in column...

I need to calculate a % based on a grouped totalin a pivot table. I've tried calculated field & items but can't get them to work. If I use a calculated item I...

Hello! I have a list 9000 rows of data and am trying to figure out a way to analyze the data in a separate sheet tab by looking at the list of data at every...

have a column showing date of action next column shows next action date as 12 months date. next column needs to show days couning down from 365 to 0

Hi, I have a series of dates in "Daily!" worksheet, cells C2:IV2, starting from 1-Jan-05 and running through till 11-Sep-05. In cells A6:A62, I have various...

I'm still learning all the capabilities of the SUMPRODUCT function and need help adapting it to my current purpose. I have a column of dates, and I am trying...

I have 100+ funds with ratings from different managers that I need to summarize across each fund. so manager 1 manager2 ... fund 1 buy sell ...

I have a workbook with 100 tabs. Can I build a search button to find the correct tab(sheet) from anywhere in the workbook?

I have a very simple workbook, just names and address. In cell B2, I am using the CONCATENATE formula as follows: =CONCATENATE("Attn: ",E2) The formula is...

I know this can be done.....just don't know how. Trying to create a formula that would leave the cell Column C1 empty if the result of Column A1 minus-Column...

I need to change the date of my workbook to the week ending date. In other works, when I open my workbook on any given day of the week, it will adjust my date...

I have a simple workbook with names and address. In cell B2 I have the following formula, =CONCATENATE("Attn: ",E2) This is what shows in the cell, not the...

How do you calculate the percentage of Improvement when the start value and the new value are both negative? For example if in 2003 we had -$15,000 and in 2004...

Hi, I'm trying to insert a Hyperlink into a cell. The length of the hyperlink, is 322 characters. When I use the Insert Hyperlink menu, the hyperlink...

Hello, I have two list that contain matching data. I need to be able some how programatically shuffle the data in both list without going one by one to make...

Can I format a cell to have the curser automatically go to a different specified cell?

HI, I currently use this formula: =SUMPRODUCT(--(AM3:AM10000=TIME(0,0,0)),--(AM3:AM10000=TIME(0,29,59)),--(AO3:AO10000=1)) How do I paste this into...

Is there a way to assign passwords to individual worksheets within a workbook? And I need it so others can not see or open someone else's worksheet. Possible?