Recent content by Jesse

Hi BM, Excel date values are coded in a consecutive number system, so you can subtract one date from the other with the result being the number of days in between. Your values need to be formatted as dates. Hopefully this helps, otherwise post a link to your spreadsheet so we can have a look.

Bonjour Deb, Thanks for responding! The average I'd like to get will be calculated by the Pivot Table (option "Average" for "Display value as") as opposed to manually. The Level1 and Level2 are not guaranteed to be sorted. Pivot table averages are by default equally weighted. But when...

Goodness! How did I miss that one. Merci (aka "Thank you" in French) Deb :) Jesse

Hi there, how can we shorten this? =SUM(SUMPRODUCT(A1:W1,A11:W11),SUMPRODUCT(A2:W2,A12:W12),SUMPRODUCT(A3:W3,A13:W13),SUMPRODUCT(A4:W4,A14:W14)) It's summing the sumproduct of 4 paired arrays.. I've tried using MMULT with TRANPOSE, but it doesn't give me the same result...

Hi Narayank991, my apologies. The posted link counts the number of unique Level2's within each Level1, and displays it on each row. I use this in my calculation of the weighted average. From the data above, example output: Level1 Level2 Average Water Quantity =AVERAGE(31,23) = 27...

Wow, thank you! I feel enlightened (and a little lighter also). I really appreciate it :)

Great, thanks Hui! (Maybe I'm asking too much at once...)

I'm having the same problem - tried to start a new topic, along with replies. Any help, or what could I do?

Greetings again! I know Pivot Tables can calculate averages, sums, etc., but can they calculate weighted averages? Below is a table with categories (Level1) and Sub-categories (Level2). Within each sub-category, I want the average (simple enough). For the category (Level1) I want the...

Hi all, I'm creating a questionnaire, which will be linked to a small dashboard. I'd need to transpose a table that maintains links to the original table. I've tried to many things! Here's a file that explains more and shows my plan so far. I originally posted a related question here...

Anyone able to do this? Choosing "transpose" in the Paste Special menu grays out the Paste Link option. AND/OR I have a reasonable array of cells (~15 rows x 24 cols), populated by a conditional reference to another cell: =IF(C6="", "", C6) - I want to transpose paste this...

Great, thanks!

Hi there, is it possible to change my icon/picture? My face looks stressed out, it makes me feel tense just looking at it! Many of your faces look so nice and calm; your tranquility is contagious.

Great, thanks Narayank991 (and SirJB7!). I looked at some of their source code and found that the password to unprotect sheets is "SunShine". Anyways, I had a thought that may simplify this, if it can be done. Idea #1: Have a static text in a TextBox in a column to the left, and have a button...

Hi there, I'm creating an assessment tool (to evaluate water security in rural, resource-limited communities) and would like to provide guidance As Needed by the users. I'd also like to save screen space and not overwhelm the user, so I'd like to rule out using simple text boxes. My...