Beautiful Sunny! Thanks for the improvement/complement. Didn't think about that issue. Cheers!
Hi Hava, this is such a typical Excel thing: you think you work with numbers, but you don't. I see on most cells on sheet 'lista' in column B the w...
I have difficulties with downloading your file. It either can't be found, or is given as txt and/or doesn't contain any data in it. Maybe you can u...
Doesn't see a problem here. Place cursor in cell with a name. Tab where you find the sorting button (I work with Dutch version, doesn't know wha...
Sorry, doesn't see an attachment?
Sorry Mark but I don't understand your question even though you explained it expanded. Maybe somebody else does understand it? The file is working ...
Proven: you're not insane! I see an attachment 🙂 We'll be back on the issue this is all about. Thanks for the file!
Still no attachment Mark. Sometimes this works not logical or properly. Last time here it was best to drag and drop the file in the given area and the...
Hi Shameen, It's a lot you ask 🙂 I looked at your worksheet (thanks for that), but I'm not sure about two things: Where do you decide if a ...
For row 2 probably something as: =AND(A2="Permanent",B2<>0,B2<>4) I think that'll do.
That reminds me of an item I once read where you can make your own sorting list in the way you want it sorted. So if it's text and the purpose is to r...
Can you share your solution (or mistake) with us, so new viewers can also learn from this? Thanks!
Did you look in the VBA code??
Second one. I don't see anything counting other than the percentages on row 20. So that doesn't work either. There is no relation between something in...
Don't understand completely what your formula is doing. But: in your formula you spelled the name without the capital "J" and because you looked for a...