blank cells
4 TopicsIgnore blanks on a graph, when created by another formula: complicated
I have a table of student data over time for multiple students. I have hidden them and their performance, and allow the user to pick a student from a list to see just their performance over time in a single row. As some students join after others, I needed a formula that did not see blank scores as 0, but as blank, as the student wasn't there when the data was collected, and a 0 score indicates they are on target. This then creates a graph for the user of performance against target over time. My problem is that for those blank cells, for when the students had not joined at that time, the graph is showing their performance as zero, whilst I need it to not appear at all on the graph. My current formula is =IF((VLOOKUP(A2,A3:M79,COLUMN(),0))="","",VLOOKUP(A2,A3:M79,COLUMN(),0)). Hopefully by looking at the file/screen shot, and the instructions provided it will make sense. In this case, the student's first data set never took place, as they wern't enrolled, but it is shown as a 0 on the graph, suggesting that they were performing at their target grade at the time.Solved1.5KViews0likes2CommentsConditional Formatting return blank if cell blank
Hello, Thank you for taking the time to read this post. I have 2 If formulas that I am having a heck of a time with. What I want is for the cell to be blank if the <= or <= is blank. As it is now I will get a Pass or a Fail even if the referenced cell is blank. Here are the two formulas. =IF(LARGE(C13:D13,1)<=I13,"Pass","Fail") =IF(SMALL(F13:G13,1)>=J13,"Pass","Fail") I have read many solutions that are similar but I just cannot figure out the syntax. I would appreciate any assistance. regards, kevinSolved2.8KViews0likes2CommentsConditional Formatting - Consider Only Value as Lowest Value
When "Formatting Cells Based on Value" if there is only one cell with data out of a set of otherwise blank cells, the rule considers the existent data as highest value. This makes sense logically, but I want the lowest value, even if it is the only value, to display as such. I can't figure out how to use another rule to eliminate the blank cells from the value-based rule. Thanks in advance!Solved6.6KViews0likes2Comments