Recent content by barmacost

That's originally how I started to work the problem but to be honest that's where I got stuck. I couldn't figure out a sophisticated formula that would give me the top 5 and take into consideration all the other names already selected. Every place holder for each task would need such a formula...

Narayan, I can't get that link to work.

I would be fine if the first task the person appears in is the one that gets priority but the difficulty is that there are 187 of these tasks with varying lengths of users (some have hundreds some only a few) so Susan may appear again for another task that only has two people in which case she...

Here is a link to a similar looking file. Hope it works...first time using RapidShare site. https://rapidshare.com/files/1046479104/Book1.xls

I'm hoping someone has had this problem before and can help me with a strategy or formula but I have a list of processes and the names of people who have completed those processes and a composite score assigned to each individual. Each person is capable of completing multiple processes and...

Thanks oldchippy for the info. I will have to post an example later...workplace blocks those sites.

Not sure how to post an example but this is the formula I'm using. Like I said it works 90% of the time but there are certain cells that even though they have identical "Priorities" come up as TRUE for conditional formatting but FALSE as a formula in a cell...

Has anyone ever encountered this situation... I'm using Countifs formula with named ranges to compare two lists (on separate tabs) to highlight when cells do not match. Generally speaking it works correctly but there are certain instances where the lists match perfectly but the cell is still...

Think I got it...just changing the columnar references for each item in list seems to do the trick. Thank you Luke and Fred! =IFERROR(OFFSET($B$11,ROW(INDEX(J$11:J$34,MATCH($B$9,J$11:J$34)+IF(COUNTIF(J$11:J$34,$B$9),0,1)))-ROW($B$11),0),"None")

Thanks Fred. That would work but I want the results to show up on another page and I don't want people to have to select anything. My thought is to have a list of the column headers and then using a formula like Luke provided to determine the corresponding row header where the criteria is met.

That's close. That gives me the resulting intersecting value and quite possibly that's how I worded my question but ultimately, what I want is the column and row headers where the intersection takes place. So what price combinations give the results I want? i.e. the price combo of 15 and 10...

Sorry, second column there wouldn't be one either. Only columns 3-5 in my table produce revenue > $100

Basically we provide a service and we get paid when we initiate the service and when we complete the service. Below is a rudimentary table of what I mean. Along the top you'll see pricing for initiating the service and along the side is pricing for completing the service. I just multiplied the...

I've got a data table setup based on transaction pricing. Column headers are fees for incoming transactions and row headers are fees for outgoing transactions. The data table is dynamic based on different volume scenarios in the other part of our model. What I want to do is find some way to...

I want a simple macro to copy all data below column headers in a pivot table and paste to another sheet. I've tried multiple methods for selecting the data to copy and it always gives me the same error. "run-time error 438, Object doesn't support this property or method." Below is the code. Any...