# condensed

1. ### Calculating with measure in calculated column

I have prepared a measure that returns a certain rate determined to be calculated only within a certain part. But then when I call this measure, only blank is returned, even though the measure shows a number. I have prepared a condensed example Power Pivot model that explains what needs to be...
2. ### An easier lookup formula ?

I have four columns and five rows.....I have a formula that works, but there must be an easier way this is what I'm using,maybe it can be condensed. I might want to expand the formula to accommodate more columns, but for now...
3. ### Find cell based on value in dropdown menu

i have a spread sheet that has 2070 rows. would like to have a drop down menu based on a condensed list (107) that when selected will auto find the first row of the condensed list. i saw that someone had posted a VBA that would do what i am after but now i can't find it. 1. the condensed list...
4. ### Complex countifs formula

I am providing a sample table below: <tbody> A B A A B </tbody> I can do a Countif to get the number of A's or B's. Or something like =SUM(COUNTIF(\$A\$2:\$A\$7,{"A","B"})) to get the number of As and Bs. I would like to refer to the part {"A","B"} as a cell reference, rather than have...
5. ### Automatically naming sheets?

Hey again guys. I want to make a spreadsheet with many sheets, but I want to condense the size of the sheets, instead just numbering them. Is there any way I can manually specify that every time I create a new sheet, I want it to go up in numbers? I can't use VBA, so don't try and give me a VBA...
6. ### condensing a list for each category

In sort of a follow up to the Condensing A List Thread http://www.mrexcel.com/forum/showthread.php?t=172764&highlight=condense+list I would like to condense the list into a series of list for each category. The example below is a synoptic view with some data and does not include the full...