Search results

Hello! Can someone please explain the use of these two functions? I am having a hard time understanding them. Thanks

Hey that's neat Luke! However, where do I put the reference to where the link goes? So, if they type 23, where do I define "Department 23"? Thanks! 3G

Hi there- Looking for a non-VBA/macro way of allowing users to either type or select a value of cell to load a specific worksheet in the workbook. Users could type or select their department number, and, that would load their department specific sheet. I'm hoping to not use VBA or a macro if...

Luke...that was it! You are the MAN! Thanks so much. This rocks!!!

CSE - Control Shift Enter

Ok...here's my formula updated: =IF(ROWS(B$34:B34)>COUNTIF('Issues Log'!G:G,C$3),"",INDEX('Issues Log'!A:A,SMALL(IF('Issues Log'!$G$2:$G$206=C$3,ROW('Issues Log'!G$2:G$206)),ROW(A1)))) Before I CSE it, it returns the value of "1" which tells me, hey, at least it's pulling something back...

Gotcha! Question...what is the function of the very last ROW(A1) in the formula?

Hi Luke- I've tried to copy this formula (which is just plain awesome by the way!!!) to another section on the same page, to pick from a different worksheet than Sheet1. Additionally, the Department name is in Column G on Sheet2, not in C like Sheet1. My updated formula is as follows...

Thanks Luke! Super helpful. Maybe I didn't state it right from the start...I have 14 rows of data x 4 columns. 14 rows = 13 departments + 1 "ALL", the 4 columns = Total, 2011, 2012, 2013. I would like the option so that someone could pick either ALL of the departments (All Departments" would...

Great! Thanks Hui. Got it to work. Now, I'm having a problem with the pie chart going in the "other direction". I can only get the pie to update by picking the year from the drop down. My formula is as follows...

Ok! I got it to work, but, now I'd like to place the chart & dropdowns on a different page than the data. However, the data validation won't let me pick the list from the other page. Does this mean I need to create named ranges?

Hi Luke- Thanks! I think option B is what I want. I'll give it a shot and check back.

Hi - I am trying to make a dynamic pie chart, where the user can select up to 2 options (Department, Year). I'd like the pie chart to update automatically based on the selections. I've noticed Chandoo has a few dynamic chart tutorials (check box/etc), but, no drop down driven ones. On his...

Great!!! This worked. Didn't know about the DATEDIF. Sneaky!!

Hello- I am building a dashboard with various metrics, and, am interested in creating a list within the dashboard. I would like to be able to present a list of "projects starting this current month". I have a list of 120 projects, all of which have a start date of the first of the month from...

Hello- I have 4 columns A/B/C/D- Start Month/End Month/Duration (Months)/Hours I then have 36 columns representing each of the months for 2011, 2012, & 2013 to the right. What I need is to break out the hours into the approrpiate 36 columns, depending on their start end date. So, for...

Hi there- I read up on the "dynamic named ranges" topic, and, wonder if I need to use them instead of referencing a larger range of data than actually exists, with the expectation that data might eventually show up. Basically, I currently have a list of 125 documents in a spreadsheet. There...

Thanks Luke! I'm a bit confused though. The references keep pointing to the shet I'm in, not the master? It's not pulling anything back? Here's what I'm looking for...each department will have their own workbook that I'd like updated dynamically. So, let's take the department Legal for...

Hello- Great website with lots of awesomeness on it!!! I'm wondering if someone can offer me a solution to the following problem. I have a list of 125 documents, all of which are assigned to one of twelve departments. The list is organized by the document number in ascending value (Column...