Search results

Hello All, I am using Excel 2007. I know how to conditionally format a cell if it is blank Or say cell value = “yes” or cell Value=”no” color the cell. How to cf if the entered text is anything other than yes or no than turn red. Any pointers will be appreciated. Thanks again for...

Hello All, I have a task were i need to format cells based on conditions. The spread sheet is available here https://docs.google.com/spreadsheet/pub?key=0AisY7zbvSsm4dGlvZWNDcDBzdWlPWmZWbkR3LTdUcXc&output=html On the left hand side i have details of employee training schedule with dates...

I work with excel 2007. I have an excel spreadsheet which requires some calculations. Calculating the course fee that the company will incur this year to run the refresher program. The dates are when the employees last did the course. Eg. participants course 1 course 2 course 3...

Hello All, I would require some conditional formatting insight and help here. I have values in Col A and some hours in Col B Col A | Col B Task 1 | 23 Task 2| 44 How to apply conditional formatting to the entire col –A such that it should fill up with a color if the col B is empty ( col B...

I have a match function that selects the code and returns the position =MATCH("G222",C1:C70,0) How to change the formula to say if match found then in cell S20= completed or if not found then S20=incomplete when a match is not found it gives #NA how to work around that. appreciate all...

SUMPRODUCT CLARIFICATION A88 20 C999 10 C099 2 E888 12 E98 4 Sum product will be A = 20, C=12,E=16 = total 48 Lets say a user inputs values like this A88 20 C999 10 C099 2 E888 12 E98 4 Sum Product is A= 20, C = 10, E = 12 total = 42 Is there any way I can capture the...

Can anyone help me with this i have to sum data in excel A040 - 4 G999 - 7 C987 - 2 D998 - 4 A140 - 6 G299 - 2 I have tried the sumif funciton by adding another helper column with only the alphabets using this formula =SUMIF(F26:H38,"A",G26:G38) i want to sum all the alphabets...

Hello , I have created sql queries in my access database which provides data based on date fields entered by user. it works fine. I want to display the result in an excel sheet dynamically changing the date every week. 'SELECT JOBAllocations.Date, JOBAllocations.USERJOBNUM...

I have 25-30 excel spreadhseets which each records the task involved in a project and records the total time taken to do individual activites. Eg, file 1 - 35 hours - activy a file2 - 20 hours activy b file 3- 25 hours.activity c There is a consolidated spreadsheet has the description of...

I have a series of time related data which i want to plot on my x axis. I want to show the time say from 1:15 pm right upto midnight 12:00 pm with a differnce of 5 seconds between each scale. how can i do it. any inputs. where can i define the starting and ending of data max and minimum.

I am looking for ideas to plot a chart for active complaints to track open issues, over due complaints,closed complaints etc. more related to the progression of the complaint. Any inputs will be appreciated.

I am using Excel 2003 and working with Pivot tables. I have constructed a pivot table showing the sales values with all ranges and one for values >100,000. The source data is the same but the data is filtered in one and not in another. is there anyway i can use the same source data and...

Hi All, I have a set of task codes and its corresponding task description. Weekly i run reports based on the tast done. Eg. A123- Milling B234-Cleaning C235-Sorting P878-Welding Each week the activity may change depending on the work and i get a list of codes that have been done for the...