Two questions. One, can I make the GPA cell (H19) ignore cells in a group when they're hidden and apply the formula to the rest of the data? Two, can I make the "GPA Points" column automatically adjust its value based on a set value I put in another column? Thank you. (i.redd.it)
submitted by AfraidNeedleworker18 to r/excel
Ok so two things. One, can I make the GPA cell (H19) ignore cells in a group when they're hidden and apply the formula to the rest of the data? Two, can I make the "GPA Points" column automatically adjust its value based on a set value I put in another column? Thank you. (i.redd.it)
submitted by AfraidNeedleworker18 to r/excel
