formulaes

Good Morning Can you help. I have a skills matrix which I have designed which is completed by users. They have options they can select 4, 3, 2, 1, 0 and what I want is to count the number skills that we have with the team in a total by these values. To count from B1 to K1 the formulated...

Hi I have data with formulaes that is 50 Columns wide and each has 204 rows. I set it up this way to first be able to drag all the formulaes. My issue now and question is, how can I change the 50 columns with 204 rows layout to have 204 columns with 50 rows and not add any addition...

So i was given this question by my teacher and i solved it. 1. Copy the data onto a new worksheet. 2. It has been decided to offer a place if an applicant has a PASS in ANY THREE SUBJECTS for the next academic year. Modify the formula to cater for the new rule. HINT: There are 4...

Hi guys, Here is screenshot of case: Image View - TIS Two matrix: "bits" and "adj's %". "Bits": is derivative of input data above. E.x. (if choosed andrew and feb) than "1" appears in appropriate cell in matrix "adj's". So the issue is: using vba make formulae like "if 1 in some cell in...