Search results

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...

Hi dear chandooers, revisiting this MMULT challenge. I'm trying to find a faster alternative, including other formulae and a vba/pivot table approach, but haven't really nailed it yet. Can anyone think of a better alternative? The situation is: need to count where a range is made of multiple...

Yess sorry for responding so late but I wasn't approaching it the right way. Some rethinking plus a pivot table did it. Thanks @Nebu !

Hi Nebu, I've tried the function and it works great. Can anyone think of a efficient way of handling the operation of consolidating both the plural and singular version of the word, and summing the number of occurrences? Thanks!

Thanks Nebu! I'll see now how I can consolidate the function with getting the end result. @NARAYANK991, that's not the output, it's the actual data. You'll notice you'll find plural and singular versions of the same word in that list (House and Cat). The goal is to consolidate a single entry...

Attaching an example. There will be far more words on the actual file, another problem about my previous approach is that it took some time to process. You'll see in this example that some words appear twice (singular and plural, like House/s or Cat/s); the idea would be to sum the number of...

Actually the objective is to identify if a word comes up twice (one in singular, one in plural), and if it does, sum the number of occurrences for each. So if you have "House" with 4 occurrences, and "Houses" with 10 occurrences, the idea would be to have a single word for both that adds up to...

Hi everyone! Hoping you can help me rethink/rewrite properly the following bit of code; scenario is the following: In column "A" I have a bunch of words, singular and plural both, and next to each word (column "B") there's a number indicating the number of occurrences for each of them. What I...

HA! It works! Can't tell you how much I appreciate it. It's a hot mess with long arrays. Thanks again to both of you whizzes.

Ha but at least you help people. Ok so I've tried every parenthesis combination...o_O ... And still no progress

Hi there again, I stumbled with the array via VBA problem again... I can't get this formula to work. I'd appreciate if you could give it a look: Sub Array_Formula() Dim FormulaPart1 As String Dim FormulaPart2 As String FormulaPart1 =...