Hi Everyone
I need help with a CountIF statement for Excel. Sorry, i'm a bit new to doing calculations and Formulas in Excel.
This is the scenario :
I have a Colum with Dates in :
2008-0...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/16/2008 Rating: 9.8 Views: 0
hey guys, im looking to sort data in excel but maybe im asking too much.
i have a file that has 100000 rows, but in the first column it has the computer name and in the following columns it has in...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/05/2009 Rating: 8.2 Views: 0
I am trying to calculate what date a process will be done, starting today [now] but only working on specific days at certain times, using a cell reference for inputing the number of workdays/hours ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/22/2009 Rating: 9.0 Views: 0
When I start a commercial application that was written in VB, Excel 2007 automatically launches. Excel fails and wants to send an error report. The application contines just fine. When i talked to ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
In an excel sheet i have a drop down list of countries. When a user selects a particular country , the rate which is already defined in the sheet used for the drop down, should appear in a cell cal...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/08/2007 Rating: 9.2 Views: 0
I am trying to count records if two conditions are met. In my table, I have a column that has multiple GL accounts (the column name is "G/L) and another column that has sales amounts (the column n...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/13/2007 Rating: 9.2 Views: 0
Hi there!
I have 100 rows in Excel 2007.
I add automatic filtering.
In Column D i filtering out "1977".
I get 5 rows left.
In the first of the 5 rows i write 1978 and drags down over the oth...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/19/2008 Rating: 9.0 Views: 0
On an erratic basis, Excel 2007 opens with the Status bar at the top of the screen with the rest of the screen filled with blue. There is nothing that I can do with Excel when this happens. Even ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/17/2008 Rating: 8.0 Views: 0
Hi
I need to remove non standard ASCII characters eg ÃÂàor ÃÂö and many others from excel.
is there an easy way to do this?
cheers
Stu
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/20/2008 Rating: 9.8 Views: 4
Can anyone tell me how I reference and excel 2007 drop down list to a specific cell so that whatever value is chosen in the list it adds thats to the cell?
Thanks
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
