Nice solutions both! I only don't get it why to sum the percentages? I would have thought an average will give more correct information? But that d...
Welcome here on the Forum Carsto! Oh what would it help if you give your Excel example sheet with the question. Is that possible for you? Frans
Hi Paul, I'm afraid you don't get the point of what Power BI is or how it's working. Did you watch the free webinar here on this website? Maybe ...
I think best is to copy the sheets for each person to a different file. You can also hide the four for person nr. 1, but you also have to make a co...
Well, for the finish position 1 I get it and then something like IF(A2=1,267-B2) and so downwards. Combining with A being 2 seems more difficult becau...
Hi Suhail, thanks for the explanation and your new file filled with rich colors 🙂 I think I understand what you want. But I'm afraid there are...
Hi Suhail Ali, I picked up your case and demo file, but can't figure out what you want. I think you explained it well, but I can't find the green and ...
Thanks for the sheet Brian. It helped to look for some faults. I worked some time with it and try to solve the problem, but didn't succeed. Even not w...
Hi Brian, welcome here at Mynda's Forum. The difference I see in the values in the rows 4 and 5 (more exactly G4:L5) is they are maybe not values b...
I also prefer an example Julie! But I think your problem isn't a problem: when you use a named range, you can copy and paste your formula and the name...
Hi John, Just for my interest: when do you have problems with a 'big' Excel file? I almost never have problems with 'big' Excel files and when I se...
Hi Ton, This is a well known issue. Everyone has his/hers own 'style' of making workbooks and sheets. I like the approach which is being taught ...
Hi Kris, Formula is in it's structure correct, but you made some typo's. It should be: IF(AND(D2<>"",G2<>""),"Completed", IF(AND(D2="",G2=...
This is guessing for me. Do the other Office 2016 products work normal? Is there more information on the error message? Does the Lenovo has enough mem...
I did that because you wanted two criteria to be checked and these criteria are different and have different comparisons. Your first one is the dat...