Search results

Hi, I'm using vlookup and running into an issue where, if the formula doesn't find an exact match in the lookup range, it returns the value from the adjacent row. I really want to leave it blank if there is no match. Is there a setting in the formula I'm missing or is this one of the many...

Hello, I routinely import a list of calls into Excel to analyze. The list is usually 350k rows or more. Many of the rows are blank or junk so I filter and delete them. That reduces the number of rows to about 75k. What I don't understand is that Excel still thinks that my range or list is 350k...

I just read up on the LOOKUP formula and get how it works. Luke you were right in the beginning. I should have known not to doubt you. :) Thanks all!!

But wait... The commission rate isn't on a 1:1 relationship. It is a range: More like this: 0-20% = 2% 21-30% = 3% 31%+ = 4% That is where the complexity comes in.

As always, thanks Luke!

Hi, I'm sure this has been asked and is in the forum but I must not be searching on the correct terms. Basically I need to calculate commission paid. It is paid in a tiered structure. So if their conversion rate was 0-20% they get 2% if it 20.01-30% they get 3% and 30.01%+ 4%. Because the...

That's it Luke. Thanks! The other part of the challenge is to find the Average of those same values. Is there an equivalent AVGPRODUCT function?

Ugghh. I should have know better. Can't delete this so disregard. Here is the table: Name 1/1/10 1/2/10 1/3/10 1/4/10 1/5/10 1/6/10 1/7/10 Strawberry 32 10 10 125 45 58 30 Blackberry 42 23 3 14 32 4 81 Blueberry 6 34 12 18 2 5 30 Huckleberry 8 8 76...

Hi, I'm stuck. I've been given a challenge and I am stumped. I've basically got a table with product names in one column (only 7 unique product names. they do not reoccur)and the number of that product sold in individual columns representing one day each. So Column A is product, Column B is...

Hi, I am analyzing a large list of help desk tickets. One of the things I am looking at is number of days it takes to resolve each issue. I'd like to do a pivot table to show how many issues were resolved in 1-2 days how many in 3-5, 5-10 etc. Can I do this within the PT itself or do I need to...

Kaushik, you exceeded my expectations! It's basically a VBA tutorial. Thanks!

Jason, technically you stole my name first. Otherwise I wouldn't have had to pick a pseudonym. :) Thanks to both you and kaushik. Both very informative and helpful posts!

Hi, Is there a way to filter a list, in place, based on the following logic: Column A begins with "C" and length >6 I know I can create a helper column with a formula to evaluate the above but I was wondering if you can do this with the Advanced Filter or some other tool (I can't seem...

Thanks Luke. Maybe I should just bite the bullet and learn some VBA. In your estimation, would this project be a good starter or a bit too complex to cut my teeth on?

Hello, I've got a report in CSV format that is emailed to me every morning with call activity from the prior day. Each morning I manually put all the calls into a master sheet I use for analysis and tracking. I'd like to look at ways to completely automate this. Does anyone have any...

Thanks Hui. Tried all of those and no resolution. Ended up opening the sheet on a different PC (both running Excel 2007) and it works perfectly. Must be hardware related w/ the scanner.

The entire string is 420103149400111201080189898970 But only the first 8 characters are entered. We append a "Return" to the transmission but so the selected cell moves down.

Hi All, Having trouble scanning the tracking number from a Stamps.com generated USPS label. It scans fine into Notepad and other apps with no apparent unprintable characters. When I scan into Excel, it only accepts the first 8 characters of the 30. I've got the fields formatted as Text and have...

Hi All, I must humbly come before you all again with what seems like it should be an easy question. How do you paste rows of data copied from a plain ol' range into a table? For some reason this never works for me. It will add one row to the table and put data in it but the rest of the data...

Hi Hui, Thanks for the suggestion. The issue with this is that the cyclical event I'm dealing with is on a 30 day period. The first event can occur at any date if we fail to log any activity from the device in any consecutive 30 day period. Once the first event occurs, and if we still fail to...

Thanks Luke. I'm trying to analyze month over month performance of eliminating/reducing these events. It makes it tough to compare apples to apples when some months have 30 and some 31 days. I picked a starting date and am just going to calculate the 30 day "buckets". I'm kind of proud of...

Hi All, This may be a rather vague question but I'm looking for any insight into working with 30 day cycles as compared to months. I have an event that will occur every 30 days if certain activity isn't logged. When I go to analyze the number of these events we receive by month, I run into a...

Thanks gents! Helpful as always.

Hi All, I've spent enough time struggling with what I know should be a simple task so I'm turning to the experts. What is the best way to accomplish this: If cell A <> "good", display value in cell A If cell A = "good" AND cell B = "good", display "good" If cell A = "good" AND...

That works! I think you can start charging me tutoring fees Luke as much as you help me.