Functions
in [Excel]
|
count similar text with using filters I want to count the number of occourances of a "Y" in coulumn D .. so i used a countif and it works great however when i filter another column it still counts all the "Y". ... 5 May 2010 09:20
Help with SUMPRODUCT & converting date to value I have the following Excel calculation, shown below. It is searching cells A6:A1000 on various sheets for data which fall between a certain date/period range, and is then adding the values in cells L6:L1000 together to display on the summary. The problem I have is that the data in ranges L6:L1000 are supposed ... 5 May 2010 09:20
Conditional Formatting Dear All, I am preparing a compartive statement i want to highlight the max and min a group of cells. quote-1 quote-2 quote-3 100 150 200 like this upto quote-6 I want to highlight the number max of 6 as red and min of 6 as yellow. Please do the needful . ... 5 May 2010 12:40
Match - not sure how to use this function I have created a Validation List called Suppliers, and then once I have picked a supplier I want it to pull over the correct Account Code. An example of the list I have is: A1 B1 1 Fred Bloggs C0011 2 Snoopy C0022 3 Donald Duck C0033 4 Mickey Mouse C0044 5 P... 5 May 2010 09:20
Excel 2007 Pivot Tables compatible with 2003 I am running Office 2003, but I have been sent pivot tables created by a colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to click on the column headers in the pivot table, I get an error saying "this Pivot Table Report is not Valid". Does anyone have any suggestions how to addr... 5 May 2010 21:37
Top 10 in pivot - show rest as other or similar Hi I need to create a pivot table .... it could be revenue per. country. Let us assume that there are 30 countries. I only want to display top 10. I can find out of it so far, but I would like the remaining countries also shown, however, together as an "other" or similar. Can this ever be done. I use Excel ... 5 May 2010 14:55
About Data Validation Hi All I have excel worksheet using Data Validation for control input Value. In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE Name" range It is possible select one DBNAME value, just allow select a particluar list of AREA and TABLE NAME ? e.g. DBNAME AREA Table NAME DB1 ... 5 May 2010 03:53
Count If equals x AND y Excel 2003 Col A Col B Col C 1 No Count this cell I need to count all the cells in Col C if Col A=1 and Col B=No Thanks. ... 5 May 2010 17:10
Regression Formula I'm trying to understand the Regression function- would someone be able to explain the steps to calculate Regression and the info the formula generates? Appreciate any help. ... 4 May 2010 21:19 |