Recent content by cacos

Thanks Chihiro, good tips. I always use binary, so we are on the same page there. I'm experiencing the unnecessary white screen even in basic code, just formatting a chart and doing some sorting. Nothing fancy. I've found this online: turns out having the cursor on-screen while the code runs...

Hi everyone! I've migrated to Excel 2013, and noticed that strangely all code runs waaaay slower. Not only that, but also the screen goes completely white while code is running- WEIRD. I was using 2010 before and it worked just fine, never had this issue. Actually not even when I was running...

Chihiro, tried it before but doesn't seem to work with the udf.

Hi there everyone I'm going crazy with this one. Can't seem to make a UDF to work to count how many cells are colored "green" or X by conditional formatting. I've looked everywhere and only found UDFs that tell you whether there is a condition or not, or what the possible colors are if any of...

This is great, really smooth. Appreciate your help very much Chihiro. Have a great weekend!

Hi! Right yes, they need to stay 50 each. And the other categories should be distributed proportionally when 1 of them is N/A.

Hi community, hoping you can help me with the following: I have a form where different aspects of a student are rated, each having different weights. Form is composed of 2 different sections, and each category is rated from 0 to 3. Depending on the weight for each category (they vary), student...

Perfect, thank you both! (what an honor :awesome:) I was trying to approach this the "most correct" way in terms of the math behind it; is there any explanation you can think of why this would be "valid" in terms of representing the percentages like this?

Hi everyone, hoping you can help come up with a solution for the attached file: each row represents a respondent, and they were each given a bucket from 0 to 100 points to allocate to a number of sports activities. There are 9 possible activities, but not all respondents had the option to see...

Hi everyone, long time away from this forum. I bring a tough one (I think) and is more of thinking an approach than coming up with a formula. I'm a 2007 user, and I have the attached scenario. Basically, I'd need to pull a list with the Region (column I) and Username (column J) based on whether...

Yes the (2) did it! Thanks Hui!

Hi! Trying to figure out why this conditional formatting code (Excel 2007) is not working. It's two relative conditions: - one adds borders on an entire range if the first cell in that row is not empty. - the other condition colors a cell in just column1 of that range, if that cell is equal...

Got it, thank you!

It does! But do you know how I can refer to the whole array rather than doing one column at a time? I will be more columns in the actual file. EDIT: I've just adjusted the first range to the whole 3 columns and it worked, nevermind! QUESTION: why the "/1"? THANK YOU!

Hi forum! Let's see if I can explain this one clearly: I need to compare an array of multiple columns and rows, to another of 1 column and equal number of rows. The comparison needs to be row by row, for example as you'll find in the attached example, compare all values in C3:E3 to F3, and...