General

Using Excel as a markbook for attendance and assessment
I'm using Excel to record and track my students' attendance and assessment. I would like to know how to get Excel to count up the number of sessions students have attended class, so I can then get it to calculate the percentage of classes they've been present. I have been inputting attendance into columns by da... 27 Apr 2010 17:57

Equations and Text in same Cell
I am using Excel to write a program. I would like to incorporate text within the same cell as the result of an equation but the I cannot control the number of decimal places that the output displays. I've tried using the Number tab in the Format Cell feature but nothing changes. Is there a way to control the... 27 Apr 2010 17:57

Access denied when running Excel from DOS prompt with runas co
"joel" wrote: try running as a command with the slash c option cmd/c runas /user:campc.mydomain.com\cam2 " C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft Office\Excel.exe" -- joel ------------------------------------------------------------------------ j... 27 Apr 2010 16:49

Conditional Formatting Pivottables
I am linking to SQL server and creating a pivottable in Excel '07 with the data that's returned. I would like to highlight a row when the last data column is 1.5 times greater than the total for that row. I can apply the initial conditional format I want and it works fine, but if I refresh the data the cond... 27 Apr 2010 15:40

vlookup maybe
worksheet 2 contains A1-H130. I need to pull data from column F11:F130 into sheet 1. The cells in column f either contains "posted" or "not posted". I need all "posted" items entered into sheet 1 column A without any spaces between the rows in column A. What formula can i use to do this? thanks! ... 28 Apr 2010 02:52

Sumproduct formula
I have a sumproduct formula that was working fine. In my table that it looks up to 1 of the columns contains a formula that returns Q1, Q2, etc... based on the date of another column in the table. 1 of the criteria in my sumproduct formula filters data based on the Q1, Q2 column of my table. I changed the fo... 27 Apr 2010 20:14

Joining Two formulas with the Help of AND / OR / IF Functions to g
Something like this will do since you only have 2 choices. =IF(D7="V Top 9702045619",AccountWiseReport!K5, AccountWiseReport!K40) -F7+I7-J7+K7-G7-H7 -- HTH... Jim Thomlinson "Akash Maheshwari" wrote: Hi, This is Akash Maheshwari. I am stuck with a formula and not able to break through s... 27 Apr 2010 15:40

Ignore Blanks
I have a worksheet that I copy cells from other worksheets. Just a simple copy/paste/link works great - unless the original cell is blank - and then it puts a 0% in. I need it to stay blank and not to put any value if blank but cannot figure out how to do that. I am not trying to sum or concatenate or any oth... 27 Apr 2010 15:40

adding hours and minutes
Hello I am not getting total sum when trying to add following times. I have used H;mm format. I get total of 9:20, which is wrong. How can I get accurate total? Thanks 1:50 0:45 0:40 2:40 1:40 0:20 0:30 0:00 1:30 0:25 2:40 2:30 2:30 2:40 0:50 1:05 2:15 4:00 1:20 2:40 0:50 0:25 1:10 2:00 0... 27 Apr 2010 19:06

Selecting specific cells in a column using countif
I am trying to use the countif function but want to include and exclude specific cells within the same column. Row 1 = "4" Row 2 = "4" Row 3 = "3" Row 4 = "4" Example: I want to count "4" in row 1 & row 4 but not in row 2. Any help would be appreciated. Bob M. ... 27 Apr 2010 15:40