Search results

Many thanks, especially Somendra & Narayan. Both solutions look great on first glance.

Thanks also for taking a look Narayan. I recall your name as you sucessfully helped me out last time i posted a thread probably over a year ago now. I'll try to digest the above and apply to my scenario. Of course if you are able to take a look at applying it to my sample file in post 8 that...

Hi Jeff Thanks for taking a look at my thread. As you rightly say a pivot table would be a significantly easier approach to a formula based solution and would give me all the flexibility i want to slice the data. However, my organisation is stuck on 2003 for now and pivot charts as...

Many thanks Somendra.

This should be ok

Area 1, Area 2, Area 3 would all be direct matches in the data table column B4:B1000. All Areas would not be a match. Department 1, Department 2 etc would all be direct in the data column column N4:N1000. All Departments would not be a match.

Lets say : Combo Box 1 (cell linked to A1, criteria in B1) = 2014, 2015, 2016, 2017 Combo Box 2 (cell linked to A2, criteria in B2) = All Areas (not actually a match in the data), Area 1, Area 2, Area 3, etc Combo Box 3 (cell linked to A3, criteria in B3) = All Departments (not actually a...

Hi Somendra Thanks for looking. All 3 front end combo boxes are text options for the user to select, the combo boxes are linked to cells A1,A2,A3. Adjacent cells B1,B2,B3 contain VLOOKUP formula to lookup the relevant criteria to match based on combo box position. e.g. position 1 = All...

Hi all, Looking for some input from a Excel guru much smarter than i. I'm wrestling with a SUMPRODUCT formula to count matching entries on multiple criteria. I'm still on Excel 2003 so can't use COUNTIFS etc. To give you an idea what i'm trying to achieve. I started with this...

Narayan you are an absolute legend. Worked perfectly, and it was easy for me to adapt the code to work for the other two sections. Thanks again Scott

Thanks again Narayan. Your formula has allowed me to progress nicely today. Due to the number of checkboxes i'd like to have 3 master checkboxes i.e. a Location master checkbox that will allow me to select all/de-select all locations, a Section master checkbox that will allow me to select...

Narayan WOW. Thank you so much. Appears to be working correctly based on limited tests. I'll develop the report further today and drop back into this thread later in the week with progress. I'll also try to understand exactly how your formula above is working. Regards Scott

Hi NARAYAN991 Thanks for looking. Its the former. Sub Unit 2 AND Section F AND ( Loc 10 OR Loc 12 ) Taking it further, if the end user made the following checkbox selections: CHECKBOX FIRST AREA : Sub Unit 1, Sub Unit 2 CHECKBOX SECOND AREA : Section E, F, G CHECKBOX THIRD AREA ...

Thanks again Hui Now working.... BUT it doesnt calculate the correct total if i wanted to make multiple checkbox selections e.g. two locations, multiple business units etc. Seems to work when i limit it to one selection from each section (Sub Unit, Section, Location) fine. For example...

Thanks Hui - great of you to have taken a look at my post. I've just changed the "Refers to" criteria for the 3 named ranges to the OFFSET formulas you've pasted above. However, i still get the #NA error in Data!G2? Have i mis-applied your post? Thanks Scott

Thanks bobhc. I couldn't figure out how this would help me specifically unfortunately. As mentioned - i think i'm a bit lost with it now and can't see the wood for the trees. I've managed to remove the business data from my workbook, simplify, and upload to dropbox. Hopefully this helps to...

Additional to the above that may help explain my issue From searching the site, Chandoo did a post regarding formulas to lookup values based on multiple conditions below... http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ I guess ultimately what i'm asking for in the long winded...

Hi All First time poster, long time lurker (great site btw Chandoo). Intermediate at best Excel user, so i'm looking to those more proficient than i am from this excellent site. Background : Still on Excel 2003 for now. Majority of my dynamic reports typically combine CHOOSE (linked to a...